COUNTDISTINCTS Function
The COUNTDISTINCTS function returns a single number: the total number of distinct items/rows. COUNTDISTINCTS does not need to be entered as an array formula.
COUNTDISTINCTS Syntax
COUNTDISTINCTS (theInputData, Ignore, ByRows, Case_Sense)
See the LISTDISTINCTS function for an explanation of the parameters.
|