View Single Post
  #1   Report Post  
Jordan
 
Posts: n/a
Default Advance Filter Criteria

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