|
LISTDISTINCTS.COUNT Function
LISTDISTINCTS.COUNT outputs a multi-column array of the cells or rows from the input data, where the first column/columns are the distinct items/rows and the last column is the count of that item.
If ByRows is true then the output rows are the distinct rows, but if ByRows is false then the output is 2 columns: the first column is a list of all the distinct items in the input data and the second column is a count for each distinct item.
LISTDISTINCTS Syntax
LISTDISTINCTS.COUNT (theInputData, Ignore, ByRows, Case_Sense, Sort, FillType)
See the LISTDISTINCTS function for an explanation of the parameters.
LISTDISTINCTS.COUNT should be entered as a multi-column multi-row array formula.
|
