• 460K Members
• 10.3K Online
• 558K 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)```

# 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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies