Count unique words
I have a smartsheet with a list of countries that I would like to total up the number of unique countries in the list? Basically eliminating the dups in the count.
For example:
US
UK
IR
US
CA
CA
UK
AU
would equal 5 Total Countries
thanks!
Comments
-
Hi,
There is no Count Distinct function in Smartsheet. I found this, which maybe helpful - https://community.smartsheet.com/discussion/unique-numbers-column
Sean
-
Add a checkbox column and a row ID column, then put the following formula into the checkbox column:
=IF([Row ID]@row = MIN(COLLECT([Row ID]:[Row ID], Country:Country, Country@row)), 1)
This will check the box for each single entry along with only 1 entry for each duplicate. You can then use a COUNTIFS to count how many boxes are checked.
You case is very similar to another one we just worked on.
https://community.smartsheet.com/discussion/feedback-submitter-count
-
Paul, this works great. Thanks for posting!
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives