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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

How do I invoice a cost to a custom built MS Access Accounting Database? 0
Invoice: customer database and billing information 3
Excel Lotto - How to find duplicate 6-number groups from result database? 2
How to sum by month 8
Access Default Microsoft Access Order Entry database issue 0
Function in Excel to count and list number of entries of text valuesin a row. 2
Custom AutoFilter 4
How to finding student Rank and How to upload bulk marks of each student at a time. 1

Back
Top