Filter Out data based on multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to filter out data that contains one of many criteria, (ie. show all data that does not match the criteria listed) I tried to used an advanced filter with <> in front of my criteria conditions, this didn't work. Anyone have any suggestions??
TKS
Steve
 
Can you use the Autofilter with the (Custom...) selection

Good Luck
Mark Graesse
(e-mail address removed)
 
No, I don't think so, because I need to filter out about 25 different criteria.
I have numbers that look something like this..
001-32490843
020-23580345
037-23423656
045-12542312
694-23494569

and I need to get rid of the ones that start with say, 001, 020, and 045... i have 25 prefixes that I need to get rid of, and I want to leave the other prefixes there.
 
Steve,
Another posibilty is to use a scrap colum to filter on. You can enter the following formula in an extra column and copy it down.

=MATCH(LEFT(A1,3),{"001";"037"},0)

This will produce a number for anything starting with 001 or 037, and will produce #N/A for everything else. You could then filter on the #N/A.

You could also replace the {"001";"037"} with a range on your sheet to make it easier to enter the items you want to filter out.


Good Luck,
Mark Graesser
(e-mail address removed)

----- Steve Wilder wrote: -----

No, I don't think so, because I need to filter out about 25 different criteria.
I have numbers that look something like this...
001-324908435
020-235803453
037-234236565
045-125423123
694-234945696

and I need to get rid of the ones that start with say, 001, 020, and 045... i have 25 prefixes that I need to get rid of, and I want to leave the other prefixes there.
 
Back
Top