Issues with Excel Advanced Filter

Occasional Visitor


I've been having issues with getting advanced filter to actually filter.

I made a test book just to test the function but as you can see it will run but won't filter anything stating 6 of 6 records find.

I'm not sure what I'm doing wrong because I've gotten this to work in the past and it seems to work on and off.


Excel Advanced Filter.png


Thank you!



1 Reply


It works in my sheet once i set the criteria range to $A$1:$C$2. If the criteria range is $A$1:$C$3 it would return all rows because there isn't a filter restriction in row 3 from A3:C3.

advanced filter.JPG