Navigation: FXLV4SpeedTools > Join, Compare and Merge Functions >

COUNTDISTINCTS Function

 

 

 

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.

 

 

 

Copyright © 2023 Decision Models Ltd