Formula needed - if a cell in column A matches that of any other cell in column A

Mtmoroni

Attempting a superbowl board this year virtually. I am in need of a formula that will tell me if any Cell in column A is an exact match of any other cell in column A - I would like tit to display "DUPLICATE" in another column.

Adrian Backus

Try this:

https://community.smartsheet.com/discussion/4007/identifying-duplicates-within-a-column

In Summary:

Second column counts the number of entries in the row that match the entry in question. If greater than one, displays "DUPLICATE". Otherwise displays nothing (or whatever you want).

=if(Countif([ColumnA]:[ColumnA], [Column A]@row)>1,"DUPLICATE","")

Adrian Backus

Try this:

https://community.smartsheet.com/discussion/4007/identifying-duplicates-within-a-column

In Summary:

Second column counts the number of entries in the row that match the entry in question. If greater than one, displays "DUPLICATE". Otherwise displays nothing (or whatever you want).

=if(Countif([ColumnA]:[ColumnA], [Column A]@row)>1,"DUPLICATE","")

Mtmoroni

That worked perfectly! Thank you!