Filter Multiple Criteria in Table

**Gickers1991** · 10-23-2011, 02:38 PM

Hey Guys!

I'm pretty new to excel (a newbie) and need a little help!

Basically, I have a list of different values ...

Orange
Gold
Blue
Red
Purple
Brown

(In real life - I have over 30 different colors I need to filter by)

I need to filter these but more importantly, need the data around this column i.e. as an example; location, name etc.

How do I filter multiple criteria (30 different pieces) in a large table?

Thanks, much appreciated!

example is attached

**martindwilson** · 10-23-2011, 03:01 PM

do you mean you only want to filter those colours then use advanced filter see attached
look here for more info
http://www.contextures.com/xladvfilter01.html

**Gickers1991** · 10-23-2011, 04:56 PM

thanks for the reply!

Still quite stuck though ... i've attached another spreadsheet.

How do I filter the raw data tab to include all of the criteria oppys? (so it shows the corresponding columns of status, cust number etc.)

any help is much appreciated!