Finding duplicates between six rows

Hi, I have the following data:

Please Login or Register  to view this content.

I AM looking for a way which could find the exact duplicates between six rows of given data and also displays the column number where the first duplicate has occurred the second time .
The desired solution starting from G1 until M1 should be as follows:

Please Login or Register  to view this content.

As "10,12,16,28,30,32" and "16,16,20,20,10,10" have occurred more than once in the above data, an appropriate formula should be applied so that they are the only ones to be displayed at "G1,H1,I1,J1,K1,L1"&"G2,H2,I2,J2,K2,L1". Also at M1,"6" is expected because "10,12,16,28,30,32" have occurred secondly at column number 6.

Any kind of help towards solving this problem would be very much appreciated.
Thanks

OK...Let's try this again. Not sure if the forum editor misread a formula or if I had a hardware problem (a loose nut in front of my keyboard)

Note: These are all regular formulas...NOT array-formulas.
Using your posted workbook, I used helper columns to keep the formulas understandable.
These formulas, copied down, set up the items to be counted:

Concatenate the values

Please Login or Register  to view this content.

Identify duplicates

Please Login or Register  to view this content.

This formula, copied across and down through L11, fills in the duplicate records

Please Login or Register  to view this content.

And this formula, copied down, returns the row number of the duplicate

Please Login or Register  to view this content.

Is that something you can work with?

Hi Ron, thanks for helping, i did tried to use those formulas but couldn't get anywhere , thus i have uploaded a workbook with example
please guide me so that i could know where i have made mistake.

Ron, I'm getting the same results as well.

In my haste to fix my post, I accidentally edited my original post, instead of just responding.

Originally Posted by Ron Coderre

In my haste to fix my post, I accidentally edited my original post, instead of just responding.

Ah yes. Very clever with the powers of 10 approach.