| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
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" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
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" wrote in message ... 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" wrote in message ... 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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Filter not working properly | Excel Discussion (Misc queries) | |||
| auto filter question | Excel Worksheet Functions | |||
| auto filter question | Excel Worksheet Functions | |||
| The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Hybrid Mode
