Avatar of Bright01
Bright01
Flag for United States of America asked on

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
Microsoft Excel

Avatar of undefined
Last Comment
Bright01

8/22/2022 - Mon
telyni19

You have this problem because you're mixing numeric and non-numeric data. You won't have a problem if you separate this information into two columns. Try the attached modification. This also lets you use a COUNTIFS function to count the items in the whole data set based on the current region code, which allows using the same formula for each section total, rather than having to set each formula manually with the right rows.
Filter-Filter.xlsm
Bright01

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.
ASKER CERTIFIED SOLUTION
telyni19

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Bright01

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.
Your help has saved me hundreds of hours of internet surfing.
fblack61