Formula to remove duplicates in a column
I have a column Project in sheet with same value multiple times..would like to remove the duplicates and show only the unique values as under Result in dash board or report. Can any one advise the easiest way..thanks
Answers
-
There may be a different way to achieve your goal, but this is what I'd do.
I would add in a "helper column" with a formula and have a "Created Date" System column in the sheet as well. Then the formula in the Helper Column would flag the row with the newest date per-person. That way only one row per-project is flagged, and you can use that in a Report to pull the unique names.
Like so:
This would be the formula for the Helper Checkbox column for the sheet above:
=IF(MAX(COLLECT([Created Date]:[Created Date], Project:Project, Project@row)) = [Created Date]@row, 1, 0)
It says, if the MAX date, specific to the person in the Project column (using the COLLECT function), is the same as the date in this row, then check the box.
Let me know if this makes sense or if you have any questions!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!