Advanced Filter
 

Stumped:
I select the range and datafilteradvanced 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

Advanced Filter
 

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

wal50 wrote:
Stumped:
I select the range and datafilteradvanced 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