Advanced Filter

[wal50]

Stumped:
I select the range and data>filter>advanced filter; select copy to another
location; put the column ($C:$C) I want to check for dups in "List Range";
the criteria list is filled already(A1:M923); select a place for the results
to go (AA1) and select unique records.
I get whatever is in C1 to move to AA1.
What am I missing?
Thanks

WAL

[Debra Dalgleish]

Is your criteria range really A1:M923? That overlaps the column that's
your list range.

wal50 wrote:
> Stumped:
> I select the range and data>filter>advanced filter; select copy to another
> location; put the column ($C:$C) I want to check for dups in "List Range";
> the criteria list is filled already(A1:M923); select a place for the results
> to go (AA1) and select unique records.
> I get whatever is in C1 to move to AA1.
> What am I missing?
> Thanks
>
> WAL


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html