Multiple selections in filter dropdown list
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Multiple selections in filter dropdown list
Is there a way (when you filter on a column) to select more than one choice? Say I have Western, Central, National, Senior as selections in column A and want to filter Central, National and Senior at the same time. Is there a way to do this - a macro?
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: Multiple selections in filter dropdown list
You can only select 2 with the filter using the OR.
You can choose not equal to Western to get the 3 of the 4 (use can NOT select 2 items with the AND)
If you have other combinations it may be better to make new column to filter on, create a list of items, and then use in the new column a formula with MATCH....
Steve
You can choose not equal to Western to get the 3 of the 4 (use can NOT select 2 items with the AND)
If you have other combinations it may be better to make new column to filter on, create a list of items, and then use in the new column a formula with MATCH....
Steve
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multiple selections in filter dropdown list
Which version of Excel are you using? In Excel 2007 and later you can select any combination of choices:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Re: Multiple selections in filter dropdown list
I am using Excel 2003. We will be changing to 2007 in the near future. Thanks for the help.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multiple selections in filter dropdown list
Another option in Excel 2003 or earlier is to use Advanced Filter:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Re: Multiple selections in filter dropdown list
Is there a way to get the original data back once you use advanced filter?
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multiple selections in filter dropdown list
Yes: select Data | Filter | Show All.
Best wishes,
Hans
Hans