I want users to be able to filter a table by 2 different quick filters. Example - a table of pet names, that can be filtered by individual name, as well by gender of the name.
I want the gender filter to affect the name filter by ticking the relevant names, not by limiting the options by only showing the relevant names in the filter. So the user could filter by female names, and all female names would be ticked in the second filter, but the male names would still be there, able to be ticked individually.
I haven't come across this in my searches, does anyone know if this is possible?
I'm not sure exactly what the issue is. What happens when you put multiple quick filters on the worksheet?
If you provide us with a packaged workbook we can take a closer look and try to give you a helpful solution.