Hello Friends
Please find the attached file (Counting the Unique values in the 2 columns.xlsx).
I need to calculate the contents duplicating in both Columns D and E.
In Light yellow cell I3 by formula it should show 11.
thanks in advance
Hello Friends
Please find the attached file (Counting the Unique values in the 2 columns.xlsx).
I need to calculate the contents duplicating in both Columns D and E.
In Light yellow cell I3 by formula it should show 11.
thanks in advance
Sekar
CSE formula
Formula:Please Login or Register to view this content.
SumProduct
Formula:Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Try this ...
=SUMPRODUCT((D2:D98<>"")*(D2:D98=E2:E98))
Normal enter.
Hello humdingaling and hello Phuocam
Thanks to both of you
Your formulas working well
thanks again
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks