Filter criteria from another cell?

  • Thread starter Thread starter davegb
  • Start date Start date
D

davegb

I'm doing spreadsheets with built-in filters accessible through
buttons/macros. The advanced filters use criteria fields to determine
what data to filter, i.e., a column header with a < or> and the number
in the cell beneath it. I also have than number elsewhere in the
spreadsheet with a more "user-friendly" label. Is there a way to get
the filter criteria to refer to the other cell and apply a "greater
than" or "less than" to that number? In other words, the filter
criteria would point to the value in the other cell and apply a < or >
to that value. Any ideas?
Thanks in advance.
 
In the criteria area, use the same heading as is on your date column.
In the cell below, use a formula to refer to the cell that contains the
date, e.g.: =">"&K2
 
Back
Top