SOLVED
Home

Help with MAX function

Highlighted
raffojt_89
New Contributor

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

3 Replies
Solution

Hi Raf,

 

For

image.png

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

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies