Finding duplicate values in a column only on certain responses

latheobald89201

Hello,

I want to look for duplicates in a column but only on certain cell values in the column.

In this case, any cell in the column that has the number 59 in it I want to be evaluated to see if there is a duplicate in the same column and then return a true to my check box column type. I can get this to work when I look for duplicates and eliminate blank cells, but can't seem to change to formula to only evaluate at cells with the number 59 as part of the value.

=IF(COUNTIFS([On Site Desk]:[On Site Desk], [On Site Desk]@row, [On Site Desk]:[On Site Desk], CONTAINS("59"(@cell))) > 1, 1)

Deric

Will this work?

=IF([On Site Desk]@row = 59, IF(COUNTIF([On Site Desk]:[On Site Desk], = 59) > 1, 1))

latheobald89201

@Deric That did not work. No error but did not flag any duplicates.

Kelly Moore

Hey @latheobald89201

I believe the formula provided by @Deric does work. Did you convert the formula to a column formula so that it would fill down the column?

Kelly

Deric

@latheobald89201

Your columns may be text columns, so you might try putting 59 in quotes "59".

I think I need to know more about your project in order to troubleshoot more. Maybe a screenshot and an explaination of how the data is captured or populated.