How can I find and mark double entries in a customer database?

M

Madeleine

Hi,
I have a braod customer database and want to find out which customers appear
more than once. I know how to get rid of double entries by using the function
advanced filter, but I need to know what customers were concerned.
Can anyone please advise??

Cheers :)
 
P

Peo Sjoblom

Use the advanced filter to create a unique list by selecting copy to another
location when you filter unique records only, that way you'll get a list
with no duplicates, then (assuimg you copy the list to H2:H500) in an
adjacent cell (maybe I2) use a formula like

=COUNTIF($A$2:$A$10000,H2)>1

(assuming original list is A2:A10000)

copy down

and all entries with TRUE next to them occurs more than once

or remove >1 and get the number they occur right away
 
Top