Compare two cell values in the same column
Hi all! I have a column of case numbers and I want the cells to turn red/have a flag or some other indicators if there is a duplicate (so the same case number). Is there a formula for this? I have seen a lot of formulas for comparing cell values but only if they are in different columns. Thanks!
Best Answer
-
What I would do is create a column next to your column with the case numbers and enter this formula in the new column:
=COUNTIF([Case Number]:[Case Number],[Case Number]@row
What this will do is count every time that exact number appears in the case number column and then you can setup up conditional formatting to shade the row if the result is more than 1.
Answers
-
What I would do is create a column next to your column with the case numbers and enter this formula in the new column:
=COUNTIF([Case Number]:[Case Number],[Case Number]@row
What this will do is count every time that exact number appears in the case number column and then you can setup up conditional formatting to shade the row if the result is more than 1.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!