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


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!