Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how I exclude weekend dates | Setting up and Configuration of Excel | |||
Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
I need to exclude duplicate patient names for dates of service is. | Excel Discussion (Misc queries) | |||
Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) |