Is there a way to search for "Repeats"?

B

B

I'm looking for an easy way to search for repeated values
in a worksheet. For our customer database I constantly
have to manually search through ~ 3000 names to weed out
duplicates. Does anyone know if there is a function that
could make this easier?
 
P

Peo Sjoblom

Eliminate them instead using data>filter>advanced filter, copy to another
location and unique records only
 
S

Soapydux

If you have a range of names starting in CELL A1 put this formula into the
next column

=IF(COUNTIF(A2:A18,A2)>1,"Duplicate","")
 
Top