Filtering

  • Thread starter Thread starter Mark
  • Start date Start date
Are you having a problem using Data>Filter>Autofilter or one of the other
methocds to filter? If so, post a specific question.
 
Yes. I have a worksheet that contains thousands of rows.
I then need to locate, lets say 200 rows. I understand
how to use the =text string filter, but it is too
cumbersome when I try to match for 200 strings. I guess
what I want to do is use a range as a criteria. Is that
posible?

Thanks!
 
You can use an Advanced Filter, or add a column to your table, and use
an AutoFilter.

For either option, type the criteria list on a worksheet, and use a
heading that is identical to the column that you want to filter in the
main table. For example, to filter for City:

City
Toronto
New York
London
Paris

Select the heading and cities, and name the list (e.g. CityList). There
are instructions here:
http://www.contextures.com/xlNames01.html

To use an AutoFilter --
Add a column to the main table with a heading, e.g. InList
In the first data row, type a formula that refers to the named list. For
example, with City in column G of the main table: =COUNTIF(CityList,G2)
Copy the formula down to the last row of data.
Select a cell in the table, and choose Data>Filter>AutoFilter
From the dropdown list in the InList column heading, choose 1

To use an Advanced Filter --
Select a cell in the table, and choose Data>Filter>Advanced Filter
Choose to Filter in Place
In the List box, check that the entire table is selected
In the Criteria box, type the name of the criteria range, e.g. CityList
Click OK
 
Back
Top