Forum Discussion
Advanced filtering not working in Excel 2021
Thanks - none of this works. Data is consistent to use in a filtering formula, but the so-called Advanced Filter does not work.
With assistance from a MS Customer Service Rep, we repeated all the diagnostics and changing things around sufficiently that we were both stumped.
I especially dislike bumping into these kinds of problems.
Back when I was aggressively trying to fix another thing, maybe 10 years ago or so, I paid the very expensive tech support fee - as I know it would be reimbursed if it was a real bug.
Sure enough, I distinctly recall getting the refund.
Wish MS paid a bounty for bugs. I - unfortunately - find a ton of them,
This seems one of them, perhaps.
m_tarler
Demo and video upload below.Good thing the lost hours I invested drove me to find a better approach.
Yet this is still something I want to get to the bottom of.
If, and - when this works - this will be REAL helpful.Thanks all,
DDAh ha! the problem is the headers of your filters must match the header of the column that filter is applied to. In the attached file rename "Filter1" and "Filter2" to BOTH be "Target" and then it should work. At least it did on my computer.
Fabulous - problem solved - I guess my reading and comprehension skills need practice!
Will continue to use this for the rest of my working life!!
Thanks!
CC
PS - will maybe have to hang around here a bit more. I prefer old-style telephone tech support, but this first go-round has worked out well.
