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

Similar Threads

Macro to select and delete levels of a document 2
Tagging Misspell Words with "##" 0
Office JS api to handle redo/undo , delete event for content control class 0
script or format to identify duplicate data 2
Duplicate entry in a column/row 14
Identify Duplicates in a List 1
Macro to delte Duplicate rows across multiple sheets 0
Conditional Format Formula for finding duplicates in a row 1

Top