Count unique words

kman27

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!

 

sean59916

Hi, 

 

There is no Count Distinct function in Smartsheet. I found this, which maybe helpful - https://community.smartsheet.com/discussion/unique-numbers-column

Sean

Paul Newcome

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

 

Dartwohl

Paul, this works great.  Thanks for posting!

Paul Newcome

Happy to help!