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.
Usage Notes

All values must be of the same data type in order for the function to calculate. 

For example, 1, 2, a, 2 will produce a value of 1 if counted. 1, 2, 2, 3 will produce a value of 3 because only 1, 2, 3 are distinct.