Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data - Advance Filter | Excel Worksheet Functions | |||
advanced filter criteria "begins with" and "does not begin with" | Excel Worksheet Functions | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
advance filter | Excel Discussion (Misc queries) | |||
Why does my advance filter only show one record? | Excel Discussion (Misc queries) |