Showing ties in Large, Match formula

[GoToLeep]

LARGE..I have a range of winning totals that run from c83 through au83. I am arranging them in order from highest number to the 9th highest number (positions) on row g132 through o132.

MATCH..then match each of those totals to the correct name from row c81 through au81 to show on row c131 through o131

Here are the formulas:
Starts at G132 and ends at O132
=LARGE(INDIRECT(“$C$83”):INDIRECT(“$AU$83”),1). Where the 1 changes to 2 through 9.

Starts at G131 and ends at O131
=INDEX($C$81:$AU$81, MATCH(G132, $C$83:$AU$83, 0)). Where the G132 changes to H132 through O132

These formulas as entered do not show the different names if there is a tie.

How do I accomplish this?

I tried to upload screenshots, but the files are too big.

Thank you!!

 

[Cubist]

I tried to upload screenshots, but the files are too big.

Do a mock-up small example.

 

[myall_blues]

Try using a helper row and calculate a unique value for each score in row 83, then reference that row in your LARGE Formula.

For example, in row 84:

=RANK(C83,$C83:$AU83,1)+COUNTIFS($C83:C83,C83)-1

Then:

=LARGE($C$84:$AU$84,1)

 

[Fluff]

Clear G131:O132 & enter this in G131 only

=TAKE(SORT(VSTACK(C81:AU81,C83:AU83),2,-1,1),,9)

 

[GoToLeep]

Clear G131:O132 & enter this in G131 only

=TAKE(SORT(VSTACK(C81:AU81,C83:AU83),2,-1,1),,9)

That worked beautifully!! Thank you very much!

 

[Fluff]

Glad we could help & thanks for the feedback.