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.- i tested this and it worked for me so I'm curious why it isn't working for you. as i mentioned the image you show does not have the header included on the filter criteria but maybe you tried that too. Can you share a sample sheet so we can try it also?
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,
DD
