Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This can be accomplished with <Data<Filter<Advanced Filter.
The criteria range would look like this: A B C 1 Date Date Blanks 2 =10/1/2008 <=10/31/08 3 =ISBLANK(C15) Where C15 is the first cell in your Date Column. Assuming the above criteria are in cells A1:C3, you need to select exactly that as your criteria range. Good luck, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter not showing blanks option | Excel Discussion (Misc queries) | |||
advanced filter for blanks | Excel Discussion (Misc queries) | |||
how do i filter non blanks across 5 columns at 1 time? | Excel Worksheet Functions | |||
Blanks non blanks in filter | Excel Discussion (Misc queries) | |||
Blanks non blanks in filter | Excel Discussion (Misc queries) |