Sort function with countif?

Hi DerrellSC.  Just like SnowMan55 showed, the SORT function in Excel 365 can sort on column number two. And that is basically the answer to the core question.

Creating entries for all the round-robin games is a lot more complicated - see https://nrich.maths.org/1443 - but nowadays quite possible to do without macros.

Teams/Players in column B are automatically set up in Round Robin games assuming there are enough courts for all games taking place at the same time.

Adding teams in column B will automatically count new numbers in column A.

Column L holds a randomizer for who wins and should be cleared in cell L4, if used for real.

If the number of teams are odd, one will have to pause.

The 'payamas table' in a3:c10 is named Participants.

The formula used to rank them is in cell O4;

=SORT(Participants,2,-1)

There are also some hidden helper calculations prepared for up to 32 teams.

If more teams are needed, copy cell bo4 rightwards.

There are more hidden columns to do this and there are other ways to display the result etc.

So, it's a starting point that may be be helpful.