SOLVED
Home

Help with MAX function

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

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
Need some help figuring out edge://sync-internals/
HotCakeX in Discussions on
0 Replies
Notifications from Planner in Teams
nwehl in Microsoft Teams on
1 Replies
Embedded Sharepoint List - Custom Forms not loading
sbayer in Microsoft Teams on
0 Replies
Adding Wiki Tab Issue
goatscandrum in Microsoft Teams on
1 Replies
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies