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","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding repeats in Excel 1
Finding duplicate time punch entries 1
getting a list from a database 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Is there any way of searching for duplicate cells? 1
search to identify duplicate enties in long columns of numbers 5
searching data 3
Cheap WiFi to Ethernet adaptor? 6

Back
Top