Finding Duplicate Numbers

  • Thread starter Thread starter chadhable
  • Start date Start date
C

chadhable

I have a list of customer account numbers. The list contains abou
10,000 numbers. I have imported our list into Excel. I know that b
sorting and looking at each number I will find the duplicate numbers
but I was wondering if there is another way to find duplicate numbers.
If there is a way to highlight the number or stopping at that point, bu
any information would be helpful.

Thank you for your time and your help
 
Suppose your account numbers are in column A. In a helper column you
can put this formula in row 2 (assuming you have a header row):

=COUNTIF(A$2:A2,A2)

and copy this down your 10,000 rows. This will count how many times
the account number on a particular row has occurred up to that point.
If you apply a custom filter on this column for Is Greater Than 1,
then you will see all the duplicated account numbers.

Hope this helps.

Pete
 

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

Counting number of items excluding duplicates. 1
How do you randomly assign numbers without getting duplicates? 6
Counting the number of different entries in a column 2
KEEP duplicate records 3
Access Auto Matching Duplicates? 0
Compare Duplicates 3
Duplicate Entries 3
AVERAGE WITH DUPLICATE NUMBERS 5

Back
Top