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 |
#3
|
|||
|
|||
Set up a criteria area with a heading cell the same as the heading on
the third column. In the cell below, type Yes. The list range is your main table. The copy to is the starting cell where you want to export the extracted list. Check the Unique records only if you don't want duplicate records in the extracted list. There are instructions in Excel's Help, and he http://www.contextures.com/xladvfilter01.html Il Principe wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
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) |