Advanced INDEX/MATCH Formula - is this possible?

I've been using Azumi's formula for almost a year now on a production report that I manage daily for my firm.
This formula has helped me create a "Top Producer" functionality for my report.
Things have gotten more complicated and now I'm wondering if there is a way to take this formula a step further.
We have a lot more employees so I'm finding more and more instances where there are "ties" that occur.
For example, two employees will end the week with a score of 34 and 34, creating a need for a tiebreaker.
I want the tiebreaker to be volume of goods sold.

Here are the two formulas in E2 and G2 that work together to display the employee with the most points. If there is a tie, it will list the employee highest up on the sheet.

=IF(ROWS($A$1:A1)<=3,INDEX($A$8:$A$24,MATCH(LARGE(INDEX($B$8:$B$24+(ROWS($B$8:$B$24)-ROW($B$8:$B$24))/10^5,0),ROWS(A$1:A1)),INDEX($B$8:$B$24+(ROWS($B$8:$B$24)-ROW($B$8:$B$24))/10^5,0),0)),"")

=LARGE(B6:B15,1)


Attachment 457767


Is there a way to further advance this formula so that first, it arranges the top producers based upon Score, and then by Volume?
So in the case shown here, it would display Brian, then Ryan, and finally Joseph?
Please see the attached file for reference.

If you need me to go further in detail, please let me know.
I really appreciate the help! This would be a huge improvement for my report.

Thanks!

The reason for me using the formula is so that I don't have to sort at all.
And the actual report that I use is much more complicated than the example I've provided so there are actually multiple leaderboards with multiple criteria, so sorting them isn't even an option.

Using helper column H

in H7

=B7+G7/100000

Copy down

In G2

=LARGE($H$7:$H$15,ROWS($1:1))

Copy down

In E2

=ROWS($1:1) & ") " &INDEX($A$7:$A$15,MATCH(LARGE($H$7:$H$15,ROWS($1:1)),$H$7:$H$15,0))

Copy down

Or use a CSE array formula

Formula:

Please Login or Register  to view this content.

Copy down

Smart idea, this works great!
Thanks a lot John!

Also thanks Jete and José for the additional solutions