Forum Discussion
Dustbin_Dusty
Feb 13, 2024Copper Contributor
Advanced filtering not working in Excel 2021
pls forgive is this is a dual post - I though I put this out a few days ago but I cannot find it. I use Excel to handle large sets of data. In this case, temperature data by date. The current x...
m_tarler
Feb 16, 2024Bronze Contributor
Ah 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.
Downeast_Dave
Feb 17, 2024Copper Contributor
Oops - just ran this on 120K row dataset - and while it did not look like it was working, after leaving the computer and coming back in 10 minutes, it did the job.
Sure took a while - but I'll be using this along with all the other tools I've learned through the years.
Thanks again!