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!
Bookmarks