Connection of 3 columns

[bines53]

Hello friends !

I want to connect 3 columns,$A$1:$A$11&", "&$B$1:$B$11&", "&$C$1:$C$11.
I got into the MAX function ,to get the result =14,5,17

Thank you !

 

[Somendra Misra]

Hi David,

See the file. Could not resist using OFFSET this times. But shown the steps with helper cells.

Regards,

 

[bines53]

Hi Somendra ,

Display the result in the three adjacent cells, should be more simple?
CONCATENATE Function can help.

Thank you !

 

[NARAYANK991]

Hi David ,

Try this array formula , to be entered using CTRL SHIFT ENTER :

=INDEX($A$1:$A$11 & "," & $B$1:$B$11 & "," & $C$1:$C$11,MATCH(MAX(SUBTOTAL(9,OFFSET($A1:$C1,ROW(OFFSET($A$1:$A$11,,))-1,))),SUBTOTAL(9,OFFSET($A1:$C1,ROW(OFFSET($A$1:$A$11,,))-1,)),0),{1,2,3})

Narayan

 

[bines53]

Hi Somendra ,Narayan,

You can not replace the OFFSET it CHOOSE ,The formula for giving ?

I try to check some ideas with CHOOSE,
=COUNT(CHOOSE(1,$A$1:$A$11&", "&$B$1:$B$11&", "&$C$1:$C$11))
He gives a result of zero .

Thank you !