Filter on Filter in Excel
EE Pros,
I have what appears to be a simple problem. When I do a "sort" routine on a particular Column that has different "sections", I get the section totals as part of the potential sort selection. How do I only get the "countries" or in this case, non-numeric list in the filter?
I've attached the sheet for you to see what I'm talking about. When you try to filter on column B, you will get the numbers AND the countries. I only want the countries to be displayed in the filter.
Make sense?
Thank you in advance,
B.
Filter-Filter.xlsm
I have what appears to be a simple problem. When I do a "sort" routine on a particular Column that has different "sections", I get the section totals as part of the potential sort selection. How do I only get the "countries" or in this case, non-numeric list in the filter?
I've attached the sheet for you to see what I'm talking about. When you try to filter on column B, you will get the numbers AND the countries. I only want the countries to be displayed in the filter.
Make sense?
Thank you in advance,
B.
Filter-Filter.xlsm
Last Comment
ASKER
Telyni19,
Greetings! Hope you are doing well...thanks for picking this one up. Here's the problem, I have multiple columns in my production sheet; so to separate out a separate column would be difficult. I've tried to adapt your creative response on one column (the same as in the test file I attached) and your idea works well. I must ask however, is there a way to filter the filter so I only get a filter on the countries? Another fix might be to add the additional column (for numbers) as you suggest. My question is then, can you have multiple filters on non contiguous columns? It appears that you can only set up filters on adjacent columns.
Thank you in advance,
B.
Greetings! Hope you are doing well...thanks for picking this one up. Here's the problem, I have multiple columns in my production sheet; so to separate out a separate column would be difficult. I've tried to adapt your creative response on one column (the same as in the test file I attached) and your idea works well. I must ask however, is there a way to filter the filter so I only get a filter on the countries? Another fix might be to add the additional column (for numbers) as you suggest. My question is then, can you have multiple filters on non contiguous columns? It appears that you can only set up filters on adjacent columns.
Thank you in advance,
B.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Telyni19,
Thank you for your insight. I think I'm going to have to create one adjacent column to filter on so that in the filter box I only have the Geo. locations and not the numbers. The filter used for text or color, while it will "behave" correctly, it still leaves all the choices in the filter.
I appreciate your help.........
Thank you,
B.
Thank you for your insight. I think I'm going to have to create one adjacent column to filter on so that in the filter box I only have the Geo. locations and not the numbers. The filter used for text or color, while it will "behave" correctly, it still leaves all the choices in the filter.
I appreciate your help.........
Thank you,
B.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Filter-Filter.xlsm