Apple Numbers - Ranking wins and losses for sports league

Would this do what you want?

First calculate a composite "score" that accounts for wins, losses, and ties, and then rank those scores.

Formula in E2, filled or copied down:

=B2−C2*0.1+D2*0.1

You may want to change the 0.1 weightings for a different relative importance of losses vs ties.

Formula in F2, filled or copied down:

=RANK(E2,E)

Replace the , in the formulas with ; if your region use , as a decimal separator.

If it does what you want then you can hide column E.

SG

Let me ask some questions.

Have all the teams the same numbers of games or have some teams not played all games when you create this chart?

In soccer we have the rule that a team gets 3 points for a win and 1 point for a tie, the total of your points will define your rang in the season. Do you have something similar?

Who is better? Team A has 1 win and lost 2 times, team B has 3 ties. Both teams played 3 games!

You have to define the weightings for a different relative importance of wins, losses & ties

Why do you go with 1st numbers of wins, 2nd numbers of losses and 3rd numbers of ties.

Wouldn't it be better to go with 1st numbers of wins, 2nd numbers of ties and 3rd numbers of losses (if really needed)?

Here my proposal:

Ralf

TateRedd33 wrote:

How do you prevent ties and how do you flip the rankings so the highest score is ranked #1 and then descend from there??

The example does rank the highest score as 1 and descend from there (column F).

What kind of ties are you seeing?

It would help to see your data and what specifically you want to occur. To post a screenshot, shift-command-4, drag to select area with the "cross-hairs", release, start a new post here and insert the screenshot image from the Desktop using the "mountains and moon" Image Insertion icon below the compose window here.

SG

you could just sort the table, in SG's example table

Sort Column D in Descending order

then C in ascending order

then B in descending order.

this would produce the same result basically,

you can add a basic formula to compare one row to the one above to see if the Win/Loss/Tie is exact match to find true "ties" where the teams have the exact same record.

Jason