Forum Discussion
Issues With Advanced Filter - Using Formulas Referencing Other Cells
I'm trying to filter a list of of value ranges based on whether a value entered into a cell is within the ranges. After doing some research it seems my best option is to use Excel's Advance Filter fe...
Hi Aylio ,
Please use absolute reference
=$A$1>A5
Advanced Filter applies filter criteria one by one to each cell in the range. If you use relative reference it'll be =A1>A5 for the A5; for next cell down =A2>A6, etc.