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?
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
"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?
Try Data > Filter > AutoFilter.....then select YES from the drop down arrow
atop that column....
Vaya con Dios,
Chuck, CABGx3
"claw" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks