List the first duplicate occurance

[LAVA2]

Hi,

From the following datas

Please Login or Register  to view this content.

I am trying to find a solution which lists the first three pairs , second three pairs , and the third three pairs that has multiple occurrences. Then
displays if it is first, second or third in terms of repetition.

After necessary adjustments the sorted data should reflect like this:

Thanks

[jewelsharma]

try this Array Formula in Cell E1 and drag across to G1 and below to G3:

Please Login or Register  to view this content.

Note: Array Formula must be entered/confirmed using Ctrl + Shift + Enter
(also see attached). HTH!

[LAVA2]

Thank you very for your guidence and valued support. That method works so well.