View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
MK
 
Posts: n/a
Default Need Advanced Filter with NOT equal string and OR criteria

Okay, I'll try to lay this out. The problem now is, using the Completed
criteria you gave me (and that _is_ how I indicated if they're completed), I
don't get lines returned that have NOTHING in the STATUS column.
Here's my timeline (I left off the row/column letters/numbers):

Event Milestone? Start End Status 11/28/05
12/5/05 12/12/05
Item 1 12/5 12/9 Completed
XXXXX
Item 2 12/5 12/16 In Process
XXXXX XXXXX
Item 3 12/5 1/13
XXXXX XXXXX
Item 4 Yes 3/31 4/5

(Item 4 would have x's way out in the columns for those future dates.)

My criteria could be JUST

Status
="<Completed"
Status

And all that would be returned would be the IN PROCESS item (#2).

What I REALLY want is criteria like
Milestone? 12/5 Status
Yes ="<Completed"
* ="<Completed"

to indicate that I want to see anything that's (NOT completed) AND (that is
supposed to occur any time during the week of 12/5 OR that is a milestone
(occurring any time).)

When I run that last query, though, I still DO NOT SEE BLANK STATUS items.
I really don't want to have to change all my blanks to NOT STARTED, but that
_does_ work. Why isn't it returning NULL values?

Thanks - hope this is readable!