Identifying duplicate values in a range

J

JLatham

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.
 

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

Top