Is there a way to search for "Repeats"?

  • Thread starter Thread starter B
  • Start date Start date
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?
 
Eliminate them instead using data>filter>advanced filter, copy to another
location and unique records only
 
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","")
 
Back
Top