Auto Filter Multiple Selections

[Guest]

Is it possible to select more than 2 options using custom auto filter?

I have a worksheet filled with contact names and the cities in which they
live and would like the filter results to show 3 or 4 cities at a time. Is
this possible? I have been playing with custom auto filter and so far I am
only able to view two cities at a time. Any suggestions?
Thanks

 

[Ron de Bruin]

Hi sbrimley

The limit is 2 with Autofilter
You must use AdvancedFilter to do it

My add-in have 5 options
http://www.rondebruin.nl/easyfilter.htm
Maybe you like it

 

[Guest]

You are limited to 2 criteria with Auto Filter, but you can use wild cards in
the criteria and/or change it from "equal to" to several other things. You
can also filter multiple columns (the criteria for all columns is ANDed). If
you're really stuck, Advanced Filter might give you what you need. But it's
not flexible like the auto filter, and you need to be careful to copy the
filter results to a different location or you'll lose data.

 

[Guest]

Thanks I will give it try, I am assuming that if I need to share my excel
file with other co-workers I will need to have the IT staff place it on
everyones PC or on our network. Are there any problems with doing this?

 

[Debra Dalgleish]

You could list the cities that you want to include
Then add a column to the main table, and use a formula to check if the
city is in the city list.

For example, Type a list of cities in cells M1:M4
In the main table, in cell J1, add the heading CityList
In J2, type: =COUNTIF($M$1:$M$4,C2)
where city is in column C
Copy the formula down to the last row of data
From the dropdown list in cell J1, select 1

 

[Ron de Bruin]

Hi sbrimley

No problem to do this
But if this is the only thing you will do with it then you can use Debra's example also.