Auto Filter Multiple Selections

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

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



--
Regards Ron de Bruin
http://www.rondebruin.nl



"sbrimley" <[email protected]> wrote in message news:[email protected]...
> 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

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.

"sbrimley" wrote:

> 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

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?

"Ron de Bruin" wrote:

> 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
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "sbrimley" <[email protected]> wrote in message news:[email protected]...
> > 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
>
>
>

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


sbrimley wrote:
> 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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.


--
Regards Ron de Bruin
http://www.rondebruin.nl



"sbrimley" <[email protected]> wrote in message news:[email protected]...
> 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?
>
> "Ron de Bruin" wrote:
>
>> 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
>>
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "sbrimley" <[email protected]> wrote in message news:[email protected]...
>> > 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
>>
>>
>>