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 :)

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


--

Regards,

Peo Sjoblom

"Madeleine" wrote in message
...
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 :)