Finding Duplicates

dgdrinkard

i've tried several formulas but none have worked the way I would like. Basically, If the row has a duplicate project number value from that column, then it checks the duplicate box. That's it…. Please help

heyjay

On your checkbox column property, uncheck the restrict to text box property, then apply this formula,

=IF(COUNTIF([Project Number]:[Project Number], [Project Number]@row) > 1, 1, 0)

heyjay

On your checkbox column property, uncheck the restrict to text box property, then apply this formula,

=IF(COUNTIF([Project Number]:[Project Number], [Project Number]@row) > 1, 1, 0)

dgdrinkard

Thank you heyjay! I was in the wrong column.