SOLVED

Query related to Count Duplicate Values with the help of formula

Iron Contributor

Hello Everyone, 

I have 2 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 rows/columns with duplicate values with the help of formula?  E.g. Hire Date has duplicate values.

 

Please help...

 

Here is a attached file...

2 Replies
best response confirmed by Excel (Iron Contributor)
Solution

@Excel 

=COUNTIFS($A$2:$A$54,A2,$B$2:$B$54,B2,$C$2:$C$54,C2,$D$2:$D$54,D2,$E$2:$E$54,E2,$F$2:$F$54,F2,$G$2:$G$54,G2)

Maybe with this formula. In the attached file i've added an additional sheet2 as an example to count triplicate values as well.

 

Thank you so much sir.
1 best response

Accepted Solutions
best response confirmed by Excel (Iron Contributor)
Solution

@Excel 

=COUNTIFS($A$2:$A$54,A2,$B$2:$B$54,B2,$C$2:$C$54,C2,$D$2:$D$54,D2,$E$2:$E$54,E2,$F$2:$F$54,F2,$G$2:$G$54,G2)

Maybe with this formula. In the attached file i've added an additional sheet2 as an example to count triplicate values as well.

 

View solution in original post