Advanced Filter

W

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
 
D

Debra Dalgleish

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