SOLVED

Help with MAX function

%3CLINGO-SUB%20id%3D%22lingo-sub-363313%22%20slang%3D%22en-US%22%3EHelp%20with%20MAX%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363313%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3EI%20have%20this%20kind%20of%204x3%20table%3A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EAC%20BELL%20PANZIROTT%3C%2FTD%3E%3CTD%3ESKOLATEAM%3C%2FTD%3E%3CTD%3E78%2C0%3C%2FTD%3E%3CTD%3E67%2C0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23STAYSERENO%3C%2FTD%3E%3CTD%3EUNO%20BIANCA%3C%2FTD%3E%3CTD%3E82%2C5%3C%2FTD%3E%3CTD%3E82%2C5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EZio%20porcone%3C%2FTD%3E%3CTD%3EAS%20DRUGS%3C%2FTD%3E%3CTD%3E83%2C5%3C%2FTD%3E%3CTD%3E71%2C0%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20texts%20and%20values%20in%20the%20cells%20are%20associated%20in%20this%20way%3A%3C%2FP%3E%3CUL%3E%3CLI%3EAC%20BELL%20PANZIROTT%20%3D%2078%2C0%3C%2FLI%3E%3CLI%3ESKOLATEAM%20%3D%26nbsp%3B67%2C0%3C%2FLI%3E%3CLI%3Eetc.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20am%20looking%20for%20a%20way%20to%20retrieve%20the%20text%20corresponding%20to%20the%20maximum%20value%20in%20the%20table%20(i.e.%20in%20this%20case%20%22Zio%20porcone%22).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%3C%2FP%3E%3CP%3ERaf%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-363313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364335%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20MAX%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364335%22%20slang%3D%22en-US%22%3E%3CP%3ERaffaele%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364169%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20MAX%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364169%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergej%2C%3C%2FP%3E%3CP%3Esimply%20W.O.W!%20You%20have%20been%20awesome.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%26nbsp%3Bfor%20your%20willingness.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3ERaffaele%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363398%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20MAX%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363398%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Raf%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20811px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86195iD792038F2230E065%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ethat%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DINDEX(%24B%242%3A%24C%244%2C%0ASUMPRODUCT((%24D%242%3A%24E%244%3DMAX(%24D%242%3A%24E%244))*ROW(%24D%242%3A%24E%244))-ROW(%24D%242%3A%24E%244)%2B1%2C%0ASUMPRODUCT((%24D%242%3A%24E%244%3DMAX(%24D%242%3A%24E%244))*COLUMN(%24D%242%3A%24E%244))-COLUMN(%24D%242%3A%24E%244)%2B1)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
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
Best Response confirmed by raffojt_89 (New Contributor)
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