Forum Discussion

raffojt_89's avatar
raffojt_89
Copper Contributor
Mar 08, 2019
Solved

Help with MAX function

Hi guys, I have this kind of 4x3 table: AC BELL PANZIROTT SKOLATEAM 78,0 67,0 #STAYSERENO UNO BIANCA 82,5 82,5 Zio porcone AS DRUGS 83,5 71,0   The texts and values in the ce...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 08, 2019

    Hi Raf,

     

    For

    that could be

    =INDEX($B$2:$C$4,
SUMPRODUCT(($D$2:$E$4=MAX($D$2:$E$4))*ROW($D$2:$E$4))-ROW($D$2:$E$4)+1,
SUMPRODUCT(($D$2:$E$4=MAX($D$2:$E$4))*COLUMN($D$2:$E$4))-COLUMN($D$2:$E$4)+1)
raffojt_89's avatar
raffojt_89
Copper Contributor
Mar 11, 2019

Hi Sergej,

simply W.O.W! You have been awesome.

 

Thank you so much for your willingness.

 

Best regards,

Raffaele

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 11, 2019

Raffaele, glad to help