Index(Max?

[Jamie Wagler]

Hello,

Please refer to the attached file.

I am trying to have the values from columns A14 to A46 & D14 to D46 populate in descending order from largest to smallest in the cells F12:G25 and the corresponding companies name from the A column populate beside the value.

F12:G25 should look like this

PRO 65,644
ODG 52,536
JD 5,411
KNO 5,411

etc etc

Thank you for all of your help!

 

[Luke M]

In G12:
=LARGE($D$14:$D$46,ROWS($A$1:$A1))

In F12:
=LOOKUP("ZZZ",$A$1:INDEX($A$14:$A$50,MATCH(G12,$D$14:$D$50,0)))

Fill down as needed.

 

[Jamie Wagler]

THANKS!!!