Forum Discussion
Solved
Count Duplicate with the help of Excel Functions
Hello Everyone, I have two questions : 1 -- Tells how many rows/columns have duplicates with the help of formula? E.g. 2 rows and 3 columns have duplicate values. 2 -- Tells the specific r...
As Riny_van_Eekelen points out, the question does not make much sense in the context of the given dataset. The possible solutions also depend on the version of Excel you have. For example, using Excel 365 one could define a Lambda function
= LAMBDA(range, LET( distinct, UNIQUE(range), duplicated?, COUNTIFS(range, distinct) > 1, SUM(N(duplicated?)) ) )so that applying it column by column
= BYCOL(Table1, CountDupsλ)gives
As Riny_van_Eekelen points out, the question does not make much sense in the context of the given dataset. The possible solutions also depend on the version of Excel you have. For example, using Excel 365 one could define a Lambda function
= LAMBDA(range,
LET(
distinct, UNIQUE(range),
duplicated?, COUNTIFS(range, distinct) > 1,
SUM(N(duplicated?))
)
)so that applying it column by column
= BYCOL(Table1, CountDupsλ)gives
Thank you so much sir.