DISTINCT Function

Used within another function to return an array of unique values in a range.
Sample Usage
COUNT(DISTINCT([First Results]:[Second Results]))
Syntax
DISTINCT(
  • range
)
  • range
    —
    The group of cells to evaluate.
Was this article helpful?
YesNo