Skip to content
Adaptam Docs

COUNT_TEXT_UNIQUE

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

Function syntax

COUNT_TEXT_UNIQUE(input1, ...)

Arguments:

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

Examples

  • COUNT_TEXT_UNIQUE(A1:A5) - If A1:A5 contains apple, 10, banana, (empty cell), apple, returns 2. Numbers and blanks/empty cells are ignored; duplicate apple is counted once.
  • COUNT_TEXT_UNIQUE(country{}) - Count of unique values in the (text) country field.
  • COUNT_TEXT_UNIQUE(country{region{“EMEA”}}) - Count of unique values in the country field where region is EMEA.
  • COUNT_TEXT_UNIQUE(country{}, C10:E15) - Count of unique text values across the country field and the range C10:E15 combined.