Filters

  • Thread starter Thread starter jgow
  • Start date Start date
J

jgow

Is there a way in Excel to Filter on Muliple selection in
the same column? For example: I would like to show only
items 1, 3, 7, and 9 from a list of 1 thru 10 numbers in
column A?
 
Use Advanced Filter.

Assume, for example, your data is in column A headed "Number". In another
column, or above the data, add the same heading, "Number" and then
underneath list 1,3, 7, and 9. If the criteria is above the data you need
to leave a blank row. Now select Data | Filter | Advanced Filter. The List
Range is the list of numbers and the Criteria Range is what you want to
filter out.

Regards

Trevor
 
To use an AutoFilter, you can add a new column to your table. If your
numbers are in column F, enter the following formula in row 2 of the new
column:

=ISNUMBER(SEARCH(F2,"1,3,7,9"))

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 heading of the new column, select TRUE
 
Back
Top