data extraction from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to pull information from one collumn. If the collumn is comprised of
yes's and no's, can excel create a list of just the yes's?
 
Try something like this:

Assuming your list is in A1:B100, with
A1: Question
B1: Response

C1: Response
C2: Yes

D1: Question (the same col heading as A1)
E1: Response (the same col heading as B1)

Select your list (A1:B100)
Data>Filter>Advanced Filter
List Range: (already selected)
Criteria Range: C1:C2

Click the [OK] button to filter the list in place.
OR
To copy the matching records to another area:
Click: Copy to another location
Copy to: D1:E1 (which contains the col headings)
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Try Data > Filter > AutoFilter.....then select YES from the drop down arrow
atop that column....

Vaya con Dios,
Chuck, CABGx3
 
Back
Top