Functions
COUNTUNIQUE
Count unique distinct values
Try it
When to use it
When should I use COUNTUNIQUE?
Use COUNTUNIQUE to count the number of distinct values in a set, ignoring duplicates.
Used in
Syntax
COUNTUNIQUE(value1, ...)Examples
=COUNTUNIQUE({1,1,2,3,5,8,13}) // => 6
=COUNTUNIQUE({1,"one",2,"two",1,"one"}) // => 4
=COUNTUNIQUE(1,1,2,3,5,8,13) // => 6