Count non repeated
Options
how can i count those items in a column are not repeated?
Answers
-
If you don't need to know which ones don't repeat, and only want a count of how many unique items there are within the column, then this should work:
=COUNT(DISTINCT([Column]:[Column]))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!