Your subject line is truncated so can't see past "check for"
Assuming you mean duplicates.......
Select range then DataFilterAdvanced Filtercheck "unique records only" and
"copy to another location".
For more on this see Debra Dalglesih's site at
http://www.contextures.on.ca/xladvfilter01.html
Gord Dibben Excel MVP
On Mon, 21 Mar 2005 11:31:05 -0800, "Excel"
wrote:
I sorted the 7,000 names, but going down the list takes to long, I need an
easier way, I just know basics in excel