# Finding duplicates between six rows

1. ## 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

2. ## Re: Finding duplicates between six rows

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?

3. ## Re: Finding duplicates between six rows

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.

4. ## Re: Finding duplicates between six rows

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

5. ## Re: Finding duplicates between six rows

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

6. ## Re: Finding duplicates between six rows

thanks a lot ron, that was dynamic idea

7. ## Re: Finding duplicates between six rows

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)