I want the cell inputs auto filter. Can it be done?
Thank You
(Edit: activated screenshot -AK)
Thank You - I will try it.
If you don’t know how it can be tricky to set up an advanced filter, I’m attaching a sample document. Advanced-Filter.ods
I defined a named range FilterCriteria
as filter criteria range pointing to $Sheet1.$C$3:$D$4
, where two criteria for the date column data in column A are defined, which are AND conjunct as they are aligned horizontally. Content of C4 and D4 is a concatenation of an operator with the date input from C1 and D1, ignore that numbers are displayed there instead of dates (these are the date serial numbers).
The filter is set up with placing the cell cursor somewhere in the date column data and then invoking menu Data → More Filters → Advanced Filter… and choosing the FilterCriteria
range for Read Filter Criteria From, which populates the input field with $Sheet1.$C$3:$D$4
, and hitting OK.
To filter for a different date range change dates in C1 and/or D1, then place the cell cursor in the date column data and choose menu Data → Refresh Range.
Thank you - Works fine - I would like the filter to auto update on date change
AFAIK there’s no auto-update.