How do I check for duplications in a range of data (excel)?

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

Guest

I have a large list of Alpha/numeric codes and I need to determine if any of
the codes are duplicated. Of course I have sorted the column and done if
manually but the list is up to 4000 rows long (a monthly occurance) and i
almost make myself blind doing it by eyesight.I have tried IF formulae but to
no avail, I am a little stuck and even our IS department are unsure as to
what to do.
Any ideas?
 
Two ways, with your data in column A, go Format, Conditional Formatting,
select 'Formula is' and enter
=COUNTIF(A:A,A10)>1
and format the cell as bright yellow or whatever, all duplicates will be
yellow,

data in column A again, in B1 enter
=IF(COUNTIF(A:A,A1)>1,"")
and copy down to the end of the range, all duplicates will have 1 in the
adjacent cell in column B, sort by column B
Regards,
 
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

using duplicate function 13
Duplicate check 4
Augmenting an integer in a column to reflect duplicates in another 23
Check for duplicates? 5
How do I identify duplicated numbers in a large range of cells 2
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
How do I find minimum duplicated values in a range? 2
Spreadsheet - Deleting Duplicate Records - Self Checking 1

Back
Top