Home |
Search |
Today's Posts |
#1
|
|||
|
|||
advanced filter a range
Hi,
I am trying to filter a number of rows according to the entry in one of the columns, using the advanced filer option and copying to another location. Each of the columns has a heading. I have tried to use the Advanced Filter function, but I am confused as to what range exactly to select in the three fields: list range; Criteria range and Copy to and Unique records only. For clarity, imagine I have 10 rows and 3 columns. The third column can either have two entries: No and Yes. Basically, I want to extract all rows where the third columd is Yes. Thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filter and Criteria Range | Excel Discussion (Misc queries) | |||
missing or ill egal extract range advanced filter | Excel Discussion (Misc queries) | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |