Forum Discussion
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...
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)
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)
Hi Sergej,
simply W.O.W! You have been awesome.
Thank you so much for your willingness.
Best regards,
Raffaele
Raffaele, glad to help