Forum Discussion

Copper Contributor

Feb 13, 2024

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

excel

Formulas and Functions

m_tarler

Bronze Contributor

Feb 15, 2024

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?

Downeast_Dave

Copper Contributor

Feb 16, 2024

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

Excel_Adv_Filter_Fail_Demo_20240216.mp42.7 MB

Excel_Adv_Filtering_Demo.xlsx9 KB

m_tarler
Bronze Contributor
Feb 16, 2024
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
  Copper Contributor
  Feb 17, 2024
  m_tarler
  
  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!
- Downeast_Dave
  Copper Contributor
  Feb 17, 2024
  m_tarler
  
  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.