On your filter pull-down you can select Custom (usually the 3rd option
down), then you can select two criteria.

First criteria: Is equal to | sales
click the OR button
Second criteria: Is Equal to | postpone
click OK

Alternatively, you could use a helper column and use a code like "non-
valid" if the other column contains sales or postpone, and filter on
the helper column.

Hope this helps.

Pete

On Nov 30, 6:16 am, stocktsi
wrote:
I've got a table of data that I'm working with and trying to get displayed
the way I need it. There's a "Status" column that has one of 4 valid status
values in it. I've used autofilter to see individual cuts of each status,
but I'd also like to be able to set up a filter that would allow me to see
all non-valid status at the same time without having to specify what they are
(ie - show me any row where the status isn't one of the 4 valid options).

For example:

Status (in column N)
-------
New
Hold
Active
Close
sales
postpone

So the advanced filter would allow me to see all rows with "sales" or
"postpone" as a status.

Thanks for your help!