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
|