| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced filter dates and nulls
On Jul 17, 8:52 am, JoHickey
wrote: I would like to use the advanced filter to return all dates greater than April 1, 2007 or are null. I cannot seem to incorporate the two together. Any help would be appreciated Thanks You need to set up two criteria rows, with the "greater than" condition in one and the null condition in the other. Allan Rogg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced filter using dates | Excel Discussion (Misc queries) | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Threaded Mode
