Identifying Duplicates within a column
![Canteaug](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Can someone tell me what I am doing wrong here?
=IF(COUNTIF([Name of Individual Impacted]@row:[Name of Individual Impacted]@row, [Name of Individual Impacted]@row1) > 1, 1)
I am trying to identify duplicate case names within my master sheet. Screenshot included below. I keep receiving the unparseable message. :(
Best Answer
-
Looks like you've got a 1 where it doesn't need to be (after [Name of Individual Impacted]@row) and your column reference doesn't need to include "@row". Try this:
=IF(COUNTIF([Name of Individual Impacted]:[Name of Individual Impacted], [Name of Individual Impacted]@row) > 1, 1)
You may also consider added to your formula something that excludes rows in which the name is blank, such as the following formula:
=IF(ISBLANK([Name of Individual Impacted]@row), "", IF(COUNTIF([Name of Individual Impacted]:[Name of Individual Impacted], [Name of Individual Impacted]@row) > 1, 1))
Hope this helps!:)
Answers
-
Looks like you've got a 1 where it doesn't need to be (after [Name of Individual Impacted]@row) and your column reference doesn't need to include "@row". Try this:
=IF(COUNTIF([Name of Individual Impacted]:[Name of Individual Impacted], [Name of Individual Impacted]@row) > 1, 1)
You may also consider added to your formula something that excludes rows in which the name is blank, such as the following formula:
=IF(ISBLANK([Name of Individual Impacted]@row), "", IF(COUNTIF([Name of Individual Impacted]:[Name of Individual Impacted], [Name of Individual Impacted]@row) > 1, 1))
Hope this helps!:)
-
@brianschmidt That worked! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!