Formula for Unique Values

swaldon2

I need a formula that will check a check box column when a project name is not unique. The check box column is "Duplicate Portfolio Name" and the name column is "Portfolio Name".

heyjay

=IF(COUNTIF([Portfolio Name:Portfolio Name], [Portfolio Name]@row) > 1, 1, 0)

1 = Checked, Not Unique

0 = Unchecked, Unique

If I got it backwards, please switch 1, 0

heyjay

=IF(COUNTIF([Portfolio Name:Portfolio Name], [Portfolio Name]@row) > 1, 1, 0)

1 = Checked, Not Unique

0 = Unchecked, Unique

If I got it backwards, please switch 1, 0

swaldon2

@heyjay That worked, thank you!