Mar 08 2019 05:59 AM
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 cells are associated in this way:
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
Mar 08 2019 09:02 AM
SolutionHi 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)
Mar 11 2019 06:40 AM
Hi Sergej,
simply W.O.W! You have been awesome.
Thank you so much for your willingness.
Best regards,
Raffaele
Mar 08 2019 09:02 AM
SolutionHi 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)