Finding Duplicate User IDs in one column

Emily Miller

Hello Smartsheet community,

I'm trying to identify duplicate User IDs in the same column and in the same sheet. The typical user ID has 6 numbers in it (example: 100054). We are working with around 10k user ids.

We've tried this formula: =IF(COUNTIF([User - Employee ID]:[User - Employee ID], [User - Employee ID]@row) > 1, 1, 0), but it didn't work. Additionally, we tried around 10 other formula versions that we found by searching the community to no avail. The helper column with the check box never checked any number, even though we confirmed there are duplicates through the "sort" feature.

Thanks,

Emily

Mark Cronk

Try:

=IF(COUNTIF([User - Employee ID]:[User - Employee ID], @cell=[User - Employee ID]@row) > 1, 1, 0)

Work?

Mark

Mark Cronk

Try:

=IF(COUNTIF([User - Employee ID]:[User - Employee ID], @cell=[User - Employee ID]@row) > 1, 1, 0)

Work?

Mark