Self Updating Leaderboard Returns duplicate name

[ravioli44]

I want to have a leaderboard that self updates. Currently I have it working but the names are duplicated. I think the function I have is returning only the first one available. So essentially if there is tie I want the leaderboard to display both names not like below where its only displaying one. Below is the sheet and the formula I have currently used.

 

[Anthony47]

Have you hidden the starting data and not said what you would like to achieve deliberately or by mistake?

 

[ravioli44]

 

[ravioli44]

View attachment 110857

This is the desirable outcome. the table set it the points tally part

 

[ravioli44]

The formula works outside of a TIE

 

[Fluff]

For 2021 or 365 you can use

=TRANSPOSE(SORT(G27:J28,2,-1,1))

This goes in H33 only, but will not work in a table.

 

[ravioli44]

For 2021 or 365 you can use

=TRANSPOSE(SORT(G27:J28,2,-1,1))

This goes in H33 only, but will not work in a table.

I get spill error

 

[Fluff]

Clear all cells in H33 & I33 down & try again.
Also is that range part of a table?

 

[ravioli44]

y

Clear all cells in H33 & I33 down & try again.
Also is that range part of a table?

yes it is'

 

[Fluff]

In that case convert the table to a normal range, or put the formula in a normal range outside the table.