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


"Bob Phillips" wrote in message
...
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)

"Phil C" wrote in message
...
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