Enter the Role and Country lists on the worksheet (not in the criteria area)
In the criteria area, leave the heading cell blank.
In the cell below, enter a formula that refers to the Role and Country
lists, e.g.:

=AND(COUNTIF($K$2:$K$4,C2),COUNTIF($L$2:$L$4,D2))

where C2 contains the first Role in the table to be filtered, and D2
contains the first Country.

When you run the Advanced Filter, select the blank heading cell and the
cell with the formula as the Criteria range.


Dee wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html