Advanced Filter Not Working
 

I have a list of 408 people who need review for an award. However, of the
408 I have already entered an award for 193 people.

I have an Excel spreadheet which lists in column A the larger list and in
column B the people who already have the award. I am trying to filter the
unique records from column A by comparing column B. However, I do not seem
to be able to get the results I need; in fact I am getting no results.

Can anyone help? I was able to do this very function before with little
difficulty but seem to have a problem now.

Sorry if this is a bit vague. I can provide more information if needed.

Thanks.

Cells A1 and B1 should contain column headings, e.g. "Name"
Leave cell D1 blank
In cell D2, enter the formula: =COUNTIF($B$2:$B$194,A2)=0

Select cell G1
Choose DataFilterAdvanced Filter
Choose 'Copy to another location'
For the list range, select column A
For the criteria range, select cells D1:D2
For the Copy to range, select cell G1
Check the box for 'unique records only'
Click OK


Cthulhu wrote:
I have a list of 408 people who need review for an award. However, of the
408 I have already entered an award for 193 people.

I have an Excel spreadheet which lists in column A the larger list and in
column B the people who already have the award. I am trying to filter the
unique records from column A by comparing column B. However, I do not seem
to be able to get the results I need; in fact I am getting no results.

Can anyone help? I was able to do this very function before with little
difficulty but seem to have a problem now.

Sorry if this is a bit vague. I can provide more information if needed.

Thanks.


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

Thanks. :)

"Debra Dalgleish" wrote:

Cells A1 and B1 should contain column headings, e.g. "Name"
Leave cell D1 blank
In cell D2, enter the formula: =COUNTIF($B$2:$B$194,A2)=0

Select cell G1
Choose DataFilterAdvanced Filter
Choose 'Copy to another location'
For the list range, select column A
For the criteria range, select cells D1:D2
For the Copy to range, select cell G1
Check the box for 'unique records only'
Click OK


Cthulhu wrote:
I have a list of 408 people who need review for an award. However, of the
408 I have already entered an award for 193 people.

I have an Excel spreadheet which lists in column A the larger list and in
column B the people who already have the award. I am trying to filter the
unique records from column A by comparing column B. However, I do not seem
to be able to get the results I need; in fact I am getting no results.

Can anyone help? I was able to do this very function before with little
difficulty but seem to have a problem now.

Sorry if this is a bit vague. I can provide more information if needed.

Thanks.


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