Using INDEX MATCH and dealing with duplicate ranked values returned

Hi Everyone,
I'm struggling with how to solve this and not sure if it's possible by using the formula. I think there will only be 2 duplicate values maximum.

I'm attaching a screenshot of a simplified version of the sheet and wonder if anyone can see if it's possible to overcome the duplicate values returned issue as my brain is melting down :D

screen.jpg

Cells C4 - C8 I'm trying to show the 'top 5' largest results in order from the data in F4 - G14.

It all works, apart from if a value in column G is a duplicate value (ie they are both ranking joint 3rd with a value of "20" in this case, it gets confused and just puts "Agricultural Products" in C6 and C7 instead of "Agricultural Products" and "Air Freight & Logistics" (in 3rd or 4th, either way).

(In case it helps, for example, D6 contains the formula:
=INDEX($G$4:$G$14, MATCH(LARGE($G$4:$G$14, B6), $G$4:$G$14, 0))

and C6 contains:

=INDEX($F$4:$F$14, MATCH(LARGE($G$4:$G$14, B6), $G$4:$G$14, 0))

I'm stuck and can't work it out and wondered if there's any clever trick or workaround anyone might be able to point me in the right direction? My brain is mush now

Any help greatly appreciated,

All the best,
Paul

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Is your forum profile showing the version of Excel that you need this to work for?

Members will tailor the solutions they offer to the version of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent versions of Excel are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the release number in your profile (e.g. MS365 Version 2211). This is in the About Excel section further down the Account page.

Thanks.

In H4 and copy down

=RANK(G4,$G$4:$G$14)++COUNTIF($G$4:G4,G4)-1

in C4 and copy across and down

=INDEX(F$4:F$14, MATCH(SMALL($H$4:$H$14,$B4), $H$4:$H$14, 0))