Excel filter problem

[ts04]

Using: Excel 2002

I have a huge excel worksheet on which I want to apply a filter. The only problem is is that I want the filter to select records where one of the fields equals multiple values. Excel standard only provides the option to select 2 criteria.

Record 1 red
Record 2 red
Record 3 green
Record 4 blue
Record 5 red
Record 6 blue
Record 7 yellow
Record 8 purple

I want to select the records that are red, green or blue.

Can anybody help me?

Thanx in advance!

Ciao,
Tanja

 

[fneily]

Create your own Advance Filter. Copy the Color field name to some column to the right of your spreadsheet. Under the new field name, put red, green blue on separate lines - so a column with the colors you want.
Click in your original list.
Click Data - Filter - Advanced Filter
Click in the criteria range box and then select the new column for your criteria. Click OK and there's your answer. To restore, Click Data - Filter - Show All.

 

[dianemarie]

Just an FYI, when you upgrade to Excel 2007, the list of criteria now has checkboxes and you can pick as many or few as you want. The filter tool has been very nicely enhanced.