filtering a list to exclude 2 different dates
I have a large data-base type spreadsheet where each line has a due date.
In 2 cells above the data, I have due dates that change every month, the
user types in the 2 due dates that change monthly.
I would need to filter the records to exclude these 2 dates.
The user should not have to create a filter himself, only change the dates.
Using auto-filter, the problem is that I cannot use "does not equal" with a
cell reference.
Using advanced filter, it does not recognise <(H5)
Any suggestions?
Many thanks
Sarah
|