Identifying duplicate values in a range

  • Thread starter Thread starter Paul
  • Start date Start date
One easy way is to use a helper column and count the number of times an entry
on a row appears in your list.

Lets say your list goes from A2 to A204 and column C is available as a
'helper' column. Put this formula in C2 and fill down to C204

=IF(COUNTIF(A$2:A$204,A2)>1,"DUPLICATE","")

It will display DUPLICATE on rows where there are, well, duplicate entries.
 
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

Identify Duplicates in a List 1
script or format to identify duplicate data 2
Problem not counting duplicates 1
duplicate rows 3
Identify (not delete) exact duplicates 1
Duplicate values in range of fields 1
duplicate cells 1
Duplicates Deletion ? 2

Back
Top