Advanced filter criteria

P

Phil C

Hi Guys

I set up a criteria range in connection with advanced filter.
Is there an OR syntax for a criteria?
I am trying to enter "Black" OR "Purple" but no joy.
Do you have to put 2 rows in the criteria range??

Thanks for your help

Phil
 
B

Bob Phillips

Yes, one value on one row, the next on the following, and then include all 3
cells (inc. header) in the criteria.

--
HTH

Bob

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

Phil C

Many thanks Bob

I knew that was lurking at the back of my brain somewhere!
Could have used custom autofilter, of course, but this method is more
flexible and you can save the 'query'.

Phil
 
J

JMay

Seems like In the Case of **OR** in advance filtering
one has to Stair-Case Their Criteria

Criteria Range (would look like so) J1:K3:
J K
1 Color Color << repeated twice in separate columns
2 Black
3 Purple

Just my 2 Cents...
 
Top