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

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" <Madeleine@discussions.microsoft.com> wrote in message
news:A180A8A2-A19F-4926-9E6A-5352D43152B6@microsoft.com...
> 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