Counts the number of unique values in a dataset.
Sample Usage
COUNTUNIQUE(C5:C7)
COUNTUNIQUE(C5:C7,C10:C15,1,2)
Syntax
COUNTUNIQUE(range1, [range2,...])
- range - The first value or range to consider when counting.
- range2 - [OPTIONAL] Additional values or ranges to consider when counting.
Examples
COUNTUNIQUE(C5:C7) returns a count of the number of unique values in the range C5:C7.
COUNTUNIQUE(C5:C7,C10:C15,1,2) returns a count of the number of unique values in the provided ranges/numbers.