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.