View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phil C Phil C is offline
external usenet poster
 
Posts: 19
Default Advanced filter criteria

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