View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah Sarah is offline
external usenet poster
 
Posts: 231
Default 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