I have a list of players in Google Sheets that assigns them a rank based on wins, followed by some more match variables — standard stuff.
I then use the rank to order the players in a league table format.
However, when I have two more players with the same rank, I hit a problem. The easiest way to illustrate it is with a link to the spreadsheet. Left side is the data, right side is the outputted table:
My aim is:
- To allow drawing players, and thus output:
- But also to add players with a rank of 0 (already calculated) to the bottom of the list, in no particular order, but below those who have played.
Please Login or Register to view this content.