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. A mock-up would be helpful. I am not quite following what you need.
For now, my suggestion would be to name the cell A1 that contains the value and the use the name on the formula.
For example, name A1 as "MyValue" and then use the formula "=MyValue>=A5"
I am not sure if this would work. It's just an idea that might work.