Filters

[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?

 

[Trevor Shuttleworth]

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

 

[Debra Dalgleish]

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

 

[Dave Peterson]

Debra Dalgleish has some instructions at:
http://www.contextures.com/xladvfilter01.html

and especially:
http://www.contextures.com/xladvfilter02.html