Finding duplicate values in a column only on certain responses
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)
Answers
-
Will this work?
=IF([On Site Desk]@row = 59, IF(COUNTIF([On Site Desk]:[On Site Desk], = 59) > 1, 1))
-
@Deric That did not work. No error but did not flag any duplicates.
-
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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!