Skip to content
Adaptam Docs

COUNT_UNIQUE

Count of unique numeric values in cells, ranges, or data fields. Non-numeric values (text, dates, blanks/empty cells, Booleans, errors) are ignored. Duplicates are counted once.

Function syntax

COUNT_UNIQUE(input1, ...)

Arguments:

  • input1, …: One or more numbers, cells, ranges, or data fields.

Examples

  • COUNT_UNIQUE(A1:A6) - If A1:A6 contains 10, 20, 10, hello, (empty cell), 30, returns 3. Text and blanks/empty cells are ignored; duplicate 10 is counted once.
  • COUNT_UNIQUE(revenue{}) - Count of unique values in the (numeric) revenue field.
  • COUNT_UNIQUE(revenue{continent{“Asia”}}) - Count of unique values in the revenue field where continent is Asia.
  • COUNT_UNIQUE(revenue{}, C10:E15) - Count of unique numeric values across the revenue field and the range C10:E15 combined.