• 396K Members
• 3,230 Online
• 431K Conversations
SOLVED

New Contributor

# 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 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

# Re: Help with MAX function

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)
Highlighted

# Re: Help with MAX function

Hi Sergej,

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

Thank you so much for your willingness.

Best regards,

Raffaele

# Re: Help with MAX function

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 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
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies