Advanced Filter

D

Dee

I am using the advanced filter to extract information from my spreadsheet. I
setup the filter in the following way

PI Name Name Role Country
Principal Brazil
Sub Mexico
Specialist Argentina

When it filters it only gives me two of the criteria. It will give me
Prinicpal and sub in Brazil and Mexico but not specialist and Argentina. What
I want is all principal, sub and specialists in Brazil, Mexico and Argentina.
Have I entered the criteria wrong? If so how would I enter the criteria to
get the results I am looking for.

Thanks in advance for your help.

Regards,

Dee
 
B

Bob Phillips

I think you have to specify the combinations

Role Country
Principal Brazil
Sub Mexico
Specialist Argentina
Principal Mexico
Sub Argentina
Specialist Brazil
Principal Argentina
Sub Brazil
Specialist Mexico




--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
P

PancakeBatter

Hi Dee- Check out Advanced Filter. For Excel 2002, this appears to allow
more than 2 values for each column of data.

Or, a quick way would be to:

Copy the Country column to new column CountryCopy. Replace Brazil, Mexico,
Argentina in CountryCopy with ZZBrazil, ZZMexico, ZZArgentina. Data, Filter
column
Role with "begins with" "s*". Data Filter column Country Copy with
"begins with "zz*".

PB
 
Top