Query related to Count Duplicate Values with the help of formula

Super 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 Zain123 (Super Contributor)



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.