data extraction from excel
 

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?

data extraction from excel
 

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)
DataFilterAdvanced 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


"claw" wrote:

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?

data extraction from excel
 

Try Data Filter AutoFilter.....then select YES from the drop down arrow
atop that column....

Vaya con Dios,
Chuck, CABGx3


"claw" wrote in message
...
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?