Create a ranking

JWesty 

This is a 365 implementation that relies upon Lambda functions.

It uses REDUCE to update the ladder for each game result in turn.

"Worksheet formula"
= REDUCE(ladder, SEQUENCE(ROWS(GameTbl)), Updateλ)

"Updateλ(current, idx)"
= LET(
    challenger, INDEX(GameTbl, idx, 2),
    challenged, INDEX(GameTbl, idx, 3),
    outcome,    INDEX(GameTbl, idx, 4),
    aspired,    IF(current = challenged, challenger, NA()),
    removed,    IF(current <> challenger, current, NA()),
    reordered,  TOCOL(HSTACK(aspired, removed), 3),
    IF(outcome, reordered, current)
  )

I hope the attached demonstrates the calculation works despite looking nothing like a 'proper' spreadsheet!

JWesty 

Creating a dynamic ranking system based on match outcomes without a points-based approach is certainly possible in Excel. You can use a combination of Excel formulas and sorting to achieve this. Here is a step-by-step guide:

Set Up Your Spreadsheet:

Assume your data is organized with columns like Player, Challenger, Opponent, and Outcome.

1. Columns Setup:
• Column A: Player Names
• Column B: Challenger Names
• Column C: Opponent Names
• Column 😧 Outcome (Win or Loss)

Create a New Column for Match Results:

1. Column E: Match Result:
• Use a formula in column E to determine the match result based on the outcome. For example:

=IF(D2="Win", B2, IF(D2="Loss", C2, ""))

• This formula will populate the name of the opponent in column E for wins and the challenger for losses.

Create a New Column for Match Positions:

1. Column F: Match Position:
• Use a formula in column F to find the position of the match result in column E:

=MATCH(E2, A:A, 0)

• This formula finds the position of the opponent/challenger in the list of players.

Update the Ranking:

1. Ranking Column (G):
• Use the RANK function to create a dynamic ranking based on the match positions:

=RANK(F2, F:F, 0)

• This formula assigns a rank to each player based on the match positions.

Sort the Data:

1. Sort the Data:
• Sort the data based on the ranking column (Column G) in descending order.
• Click on the header of the column you want to sort (e.g., G) and choose "Sort Largest to Smallest."

Now, as matches are played and outcomes are entered, the ranking will automatically update based on the match results. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.