Forum Discussion
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...
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.
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.