View Single Post
  #3   Report Post  
Art Farrell
 
Posts: n/a
Default

Hi Jordan,

For Advanced Filter you could use:

=OR(A2="Yes",AND(B2="One",C2="Phoenix"))

CHORDially,
Art Farrell

"Jordan" wrote in message
...
Help! I am trying to use the Advance Filter to eliminate rows from a

list.
Using this example:

Column A B C
Yes One Phoenix
No One Tucson
Yes Two Phoenix
No One Phoenix
Yes Two Tucson

I need two criterias. (1) if A is = to Yes OR (2) B = to One AND C =

Phoenix

The results would be:

Column A B C
Yes One Phoenix
Yes Two Phoenix
No One Phoenix
Yes Two Tucson

Any help will be greatly appreciated.

Jordan