Finding a trio and a pair the most common into one cell

[bines53]

Hello friends !

Attached a file with an example .

Thank you !

 

[Mike H..]

Hello friends !

Attached a file with an example .

Thank you !

Hi,

The only thing we have that explains the requirement is the title of your post. Could you explain a little more what we're trying to do?

I assume the answer for row 1 is in Cells I2 & J2. Please explain why this is the answer?

 

[bines53]

Hi Mike ,

Sorry ,I forgot to write the explanation in the file before.

I want a formula that will give them both a trio of numbers that appears the most in the lines, in range A2: F12, and two pairs of numbers.
The solutions required, I recorded manually in columns I and J.

Thank you !

David

 

[Somendra Misra]

Hi David,

Since your manual answer was from range B2:D12, I had formulated a formula in yellow range based on these columns. See the file, the same can be repeated for two result also. Also note that since right now there are only 3 columns so concatenation was easy but if you have many more columns than VBA will be best to approach this problem (this is what I think, might be there will be a formula which can concatenate 10 columns or so)

Regards,

 

[Mike H..]

Hi Mike ,

Sorry ,I forgot to write the explanation in the file before.

I want a formula that will give them both a trio of numbers that appears the most in the lines, in range A2: F12, and two pairs of numbers.
The solutions required, I recorded manually in columns I and J.

Thank you !

David

Hi,

I still don't understand the rules of this. When we look for doubles or trebles do they have to be aligned in columns as they are in your sample workbook or can a set of double/trebles appear anywhere in the row?

 

[bines53]

Hi Somendra,

I meant to cover all 6 columns,
If possible solution with VBA ?

Hi Mike,
If one range, I want to extract triplets and pairs, how approach something like this?

Thank you !