Using <> in Advanced Filter criteria

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

I have a list of data that I want to separate based on a customer
type. I want all customers with a type of "HOSPITAILITY" or "HOTEL"
separated onto a new tab and then I want all customers that don't have
a customer type of "HOSPITALITY" or "HOTEL" separted onto a different
tab. I added a criteria range with these two values in it and the
first filter works without any problems. However, I can't figure out
how to tell Excel to separate the remaining records based on the
customer type being <> "HOSPITALITY" or "HOTEL"
 
You need to use 4 cells for the criteria, if you normally would have

Header
HOSPITALITY

to filter out all entries with HOSPITALITY and let's say that would be E1:E2
as criteria range, for this you would need

Header Header
<>HOSPITALITY <>HOTEL


then use

E1:F2

as Criteria


--


Regards,


Peo Sjoblom
 
Use criteria of

does not equal HOSPITALITY

AND

does not equal HOTEL

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top