Indoor Soccer League Table Tiebreaker Help

I have spent hours searching for this, but nobody has ever given a clear answer either on this forum or anywhere on the internet. So, I figure it's finally time to buck up and post my own question to see if anybody can answer me.

I manage an indoor soccer league and we keep a pretty basic League Standings: 3 points for a Win, 1 point for a Draw, 0 for a Loss. Our leaderboard ranks teams based on the amount of points they have. In case of ties, it CURRENTLY breaks them by the following:

1. Most Wins (W)
2. Fewest Losses (L)
3. Goals Allowed (GA)
4. Goals Scored (GF)

However, what I want is for the 3rd tiebreaker to be HEAD-TO-HEAD results. IF TEAM A is tied with TEAM B in both Wins and Losses, the third tie breaker would be determined by whoever won the TEAM A vs TEAM B matchup. Since teams will play each other more than once, it would be possible for them to split the H2H matchups, and that's where the next tiebreakers come in: Goals Allowed and Goals Scored.

Here is how I HOPE to have the tiebreakers:

1. Most Wins (W)
2. Fewest Losses (L)
3. Head to Head Matchups
4. Goals Allowed (GA)
5. Goals Scored (GF)

In my current standings, there are two teams ("Timbers Indoor" & "FC United") who are tied in Games Played, Wins, Losses, Goals For and even Goals Against. However, in their Head-to-Head matchup, "FC United" won, so they should be ranked above "Timbers Indoor." But my 'Standings' sheet simply lists "Timbers Indoor" twice.

I use XL2007 and have attached my spreadsheet. Please let me know if you can help!

Thanks!

Hey guys, thanks for the help!

Between Marvin's help and the help of a friend of mine, I've been able to break 2-way ties (as long as they play each other 2 times or less), using pretty much the same formula Marvin suggested.

But now I'm getting much more involved with this league, and I know that I will soon be dealing with 3-way and possibly 4-way ties. Also, teams could end up playing each other more than 3 times.

Any thoughts on how to handle these? The same friend who helped me with the H2H tie-breaker suggested a Macro, but I'd really love to stay away from that if at all possible.

If two teams were tied H2H, then we'd advance to the third tie-breaker: Goals Against. If there was a tie there, then it would go to Goals For. Eventually, if there was still a tie, I think Record Against Common Opponents (R.A.C.O.) would come in handy, but that's a whole different formula, I'm sure.

As for 3-way ties, I'm curious how that would be broken. For example, let's say A beats B, B beats C, and C beats A. I think in that case we'd have to skip over H2H results and go to GA and GF. That is probably where R.A.C.O. would come in handiest.

This would be my ideal Ranking Criteria:

1. Ranking Points (3 for a win, 1 for a draw, 0 for a loss)
2. Most Wins
3. Fewest Losses
4. Head-to-Head
5. Goals Allowed
6. Goals Scored
7. Record Against Common Opponents

Hey Marvin,

That sounds interesting. I once created a Kickball standings workbook that included team's Strength of Schedule, which is very similar to what it sounds like you're talking about.

Here is a copy of that file (assuming you can discern the madness I was attempting!). OR stands for Opponent's Winning Percentage, and OOR stands for Opponent's Opponent's Winning Percentage. That way you get a real Strength of Schedule, which was great since you only played 6 teams out of 16.

I'll have to play around with your setup to see how it works for H2H ties.

See attached, seems to work - set up to work for anything up to a 6-way tie at present.

Also, your attachment was ranking the highest number of goals conceded as better than lowest number, so I fixed that.

Thank you!!

Now, all I have to do is put in a way to automatically generate a RANDOM league schedule based on the amount of teams and this puppy is complete.... But I will start a new thread for that.

Once I get this thing pieced together, I'll share the final version since it looks like people are definitely searching for similar worksheets.