Round robin tournament tie break via matches/games/points

Here the file

Wow, that was fast! This gives me some good ideas, but doesn't quite fix the problem. It will take me a while to test my idea out...I'm clearly waaaay to slow at this compared to you.
I'll post back if I am successful.

In your solution, Column H (point differential, Pd) sums the point differential for a player vs. all opponents instead of just the opponents who are tied.
The rank is determined based on this point differential which unfortunately is incorrect.

In this example, there is a tie between players A, B, and C. Points scored in matches that involve other (non-tied) players should not impact the outcome.

For example, Darth Vader (B) beat Han Solo (E) easily by a score of 11-5, 11-4. However, adjusting the score to 11-9, 11-9 (enter a '9' in Z5 and AA5) causes Darth Vader to be knocked down to 2nd place.

One other snag...the final solution needs to check if players are tied in terms of games won/lost. If a tie still exists, THEN points must be evaluated.

I *THINK* that I can do this in 3 stages, by creating an individual rank for matches/games/points. Will post back when I'm done (or when I realize the effort is futile).

Cheers,
Dave

Here's an update, I managed to break things into 3 sections. Added "Match Rank", "Game Rank", and "Point Rank" columns to help identify which players are involved in a tie.

RoundRobinTest_Rev2.xlsx

There are probably more concise solutions that use fewer columns and more intelligent formulas. I'm happy with the concept...I didn't believe it was possible until now.

There are still logic errors, which are easily found if you massage the match results. Once I work those out I'll mark the thread as solved.

The previous workbook did not handle multiple tied groups well, so I extended the round robin to 12 players and allowed for a best 4-of-7 match format. This makes it easier to test a wide variety of scenarios.

RoundRobinTest_Rev3.xlsx

Conditional formatting has been added at each stage of evaluation (Matches/Games/Points) to visually identify tied players.

In this example, the main group has two 3-way ties.
The 3-way tie for 9th place is resolved based on games for/against.
The 3-way tie for 4th place cannot be resolved because all statistics are equal.

The tie for 4th place should be resolved randomly. VBA may be required to automate this process.
This would be a "nice to have" but in practice it will be rare (and event organizers need to be aware of such a thing, so keeping it unresolved isn't a deal breaker).

This is a good solution in many situations, but the end result doesn't work as needed. It is required that only matches involving two tied players will be used to break a tie. This may not be the case for some activities (darts as an example), but it is recommended practice in many sports.

I extended your spreadsheet to 8 players as illustration. All matches score 11-8, 11-8 such that {B,C,D} are tied in matches/games, similarly for {F,G,H}. These ties are shown in the overall ranking.

copy RoundRobinTest_Rev2.xlsx

If you adjust the score for match D vs. F from (8,8) to (1,1) the ties are broken! However, those points should not be considered when breaking the tie because F is not involved in the {B,C,D} tie and D is not involved in the {F,G,H} tie.

I appreciate your efforts. This would be a great solution if not for the tie requirements. Ultimately, the user will see a prettier version of the round robin group, scorecard, and overall ranking (this is part of a much larger tournament spreadsheet project, meant to automate as much of the process as possible).

More importantly, thanks for pointing me in the right direction. When I started thinking about this, I believed it was impossible to do with formulas. Happy to say that I was wrong!

Cheers,
Dave

I know you testing if come to same tied score. That won't happen if you play in 3 games. If is do happen. Only way it a play off with 1 leg or 3 leg in order who 2nd, 3rd and 4th.
That how I do in 8 ball pool competition twice a year if all end up same win, for/against and point.

Cheers

I have a query, In a league tournament the If the points difference <=5 the looser team will get 1 point & winner team get 3 points. (Ex X Vs Y match the X Scores 23 & Y scores 21, then points for X=3 & Y=1 respectively) How to write a formula for this in excel.