View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stocktsi stocktsi is offline
external usenet poster
 
Posts: 10
Default Create "other" filter

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!