Navigation: FXLV4SpeedTools > Join, Compare and Merge Functions >

COUNTDUPES Function

 

 

 

COUNTDUPES Function

The COUNTDUPES function returns a single number: the total number of duplicated items/rows. COUNTDUPES does not need to be entered as an array formula.

The number of duplicated items/rows is counted as the total count of items/rows for each non-ignored distinct item/row -1.

COUNTDUPES Syntax

COUNTDUPES (theInputData, Ignore, ByRows, Case_Sense)

See the LISTDISTINCTS function for an explanation of the parameters

 

 

 

Copyright © 2024 Decision Models Ltd