Forum Discussion
Lina_Kou
Feb 06, 2023Copper Contributor
Issues with Excel Advanced Filter
Hello, 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 ...
OliverScheurich
Feb 06, 2023Gold Contributor
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.