Checkbox for Duplicates Except Those That are Unique
Hello,
I have a sheet that has lists of names, many are duplicates. I want to move the list of names into a report however I only want to see unique names in the report. To do this I need to flag the duplicates so I can filter them out in my report.
So far I have created a helper column that is counting the number of duplicates called "Duplicate Helper"
=COUNTIF([Candidate Name]:[Candidate Name], [Candidate Name]@row)
I also have another checkbox column that is to flag rows that have a duplicate
=IF([Duplicate Helper]@row > 1, 1, 0)
What I'm missing is the mechanism ensure the first unique name is not flagged as a duplicate. For example, if I have a list as follows:
Mary
Beth
Anna
Anna
Tom
Beth
John
The result I would like is that only the first instance of Beth and Anna are unchecked, the second instance are considered duplicates and are flagged. I'm not sure how to accomplish this.
Answers
-
See my solution here for a similar issue:
-
Thanks @JIDEATTURRA this worked for me!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!