Ranking the 1st places, 2nd places and 3rd places

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) 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. Thanks.

You have failed to mock up your expected results - please do this now. Thanks.

I'll have to guess, then!

First move all ranking calculatins into column M.

In P13 copied down:

=INDEX($D$6:$D$21,MATCH(1,($C$6:$C$21=1)*($M$6:$M$21=LARGE(IF($C$6:$C$21=1,$M$6:$M$21),ROWS($1:1))),0))

In S13 copied down:

=INDEX($D$6:$D$21,MATCH(1,($C$6:$C$21=2)*($M$6:$M$21=LARGE(IF($C$6:$C$21=2,$M$6:$M$21),ROWS($1:1))),0))

In P19 copied down:

=INDEX($D$6:$D$21,MATCH(1,($C$6:$C$21=3)*($M$6:$M$21=LARGE(IF($C$6:$C$21=3,$M$6:$M$21),ROWS($1:1))),0))

You may need to enter the formulae as array with CSE.

Try this.
In P13

Please Login or Register  to view this content.

In S13

Please Login or Register  to view this content.

In P19

Please Login or Register  to view this content.

All copied down.
Note changes in the formulas which are ranking numbers.