Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem organizing text data into new excel page | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |