How about just using a helper column of formulas?

=if(or(a2="yes",and(b2="one",c2="phoenix")),"keepi t","deleteit")

Drag down, apply data|Filter|autofilter and then delete.



Jordan wrote:

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

--

Dave Peterson