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:

https://docs.google.com/spreadsheets...it?usp=sharing

My aim is:

- To allow drawing players, and thus output:

1= Player 1
1= Player 2
3  Player 3
4  Player 4
- 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.