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 PANZIROTTSKOLATEAM78,067,0
#STAYSERENOUNO BIANCA82,582,5
Zio porconeAS DRUGS83,571,0

 

The texts and values in the cells are associated in this way:

  • AC BELL PANZIROTT = 78,0
  • SKOLATEAM = 67,0
  • etc.

I am looking for a way to retrieve the text corresponding to the maximum value in the table (i.e. in this case "Zio porcone").

 

Can anyone help me?

 

Thanks a lot.

Raf

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)

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    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