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 Data>Filter>Advanced 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 Data>Filter>Advanced 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
>
>