Help with formula to determine final standings in a round-robin competition

[MrTinkertrain]

Hello Excel-experts,

For a local dart-club downtown I make use of an Excel-template to enter the scores for a round-robin competition for a few pools of 4 or 5 players.
The results of that competition are used to determine whether a player goes through to a winners round (numbers 1 and 2 of each pool) or a loosers round (the rest of the players).
I would like to design a formula, which automatically determines the rank position of a player.
There are a few rules regarding how to determine the final rank of a player.
First one is the number of points acquired (1 point is acquired for each leg a player wins)
When 2 or more players have the same amount of points, I want to check the leg difference for each player (legs won -/- legs lost).
Finally when also that leg difference can't determine which player ranks higher, I want to look at the result of the match between those players (e.g. if player A and B have the same amount of points and player B has won the match between A and B, player B ends before player A in ranking position)
I guess my question will be clearer if I would post a few "screens"

The results of the matches are entered in the (yellow) cells E11-G20

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">10</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Games</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Results</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-bottom: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">A</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">C</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">D</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">A</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">E</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">D</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">A</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">C</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">E</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">A</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">D</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">E</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">C</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">C</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">D</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">vs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">E</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;background-color: #969696;;">-</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">1</td></tr></tbody></table><p style="width:3,6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">5poule</p><br /><br />

The acquired points per player are shown here :

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">22</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF00;;">Points</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">A</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">C</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">D</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">E</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Total </td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Rank</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">A</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #0000FF;background-color: #FFFF99;;">8</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FF6600;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #0000FF;background-color: #FFFF99;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FF6600;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">C</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #0000FF;background-color: #FFFF99;;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FF6600;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">D</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #0000FF;background-color: #FFFF99;;">6</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FF6600;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">E</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #0000FF;background-color: #FFFF99;;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FF6600;;"></td></tr></tbody></table><p style="width:3,6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">5poule</p><br /><br />

The leg difference is shown here :

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">20</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF00;;">Game Statistics</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF00;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF00;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF00;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF00;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF00;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Player</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Name</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Legs</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;font-style: italic;;">Won</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;font-style: italic;;">Lost</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;font-style: italic;;">Difference</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">A</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Mike</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">7</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">B</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Bart</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">8</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">-6</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">C</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Melvin</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">-1</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">D</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Martin</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">6</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">3</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">E</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Pascal</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">7</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFF99;;">-3</td></tr></tbody></table><p style="width:3,6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">5poule</p><br /><br />

I want to enter the formula in the orange cells from the second screen (I23:I27)
I've tried to use the RANK-function, but that only works if each player scores a different amount of points.

I hope I have been able to make clear what I want to achieve.
I hope someone can help me out with this one.

Thanks in advance,

Mike

 

[MrTinkertrain]

Bump

 

[Jerry Sullivan]

Hi Mike,

One approach would be to create a tie-breaker total that would be the Sum of:
100* Points
10* Descending Rank of Leg Difference
1 * Winner of Head to Head Leg

To test breaking the tie using all three criteria, I changed the example for 2 of the Legs highlighted in blue.

Darts

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Games</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Results</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold"> </TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">B</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">C</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">E</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">B</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">C</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">E</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">B</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">E</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">C</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">B</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">C</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD></TR><TR style="HEIGHT: 48px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">D</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">vs</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">E</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #969696; FONT-FAMILY: Verdana; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">-</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1</TD></TR></TBODY></TABLE>
Excel tables to the web - Excel Jeanie Html 4


Here is the result and formula....

Darts

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 81px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD></TR><TR style="HEIGHT: 33px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Rank</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">TieBreak Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Final Rank</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">610</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">520</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">430</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">431</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">3</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">450</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">3</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>J23</TD><TD>{=(100*H23)+(10*RANK(R23,R$23:R$27,0))+SUM(((100*H$23:H$27)+(10*RANK(R$23:R$27,R$23:R$27,1))=(100*H23)+(10*RANK(R23,R$23:R$27,1)))*(TRANSPOSE(C23:G23)=2))}</TD></TR></TBODY></TABLE></TD></TR><TR><TD>Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!
</TD></TR></TBODY></TABLE>
Excel tables to the web - Excel Jeanie Html 4


Please test this with some results and let me know if it works.
I'm about 90% sure it does.

 

[MrTinkertrain]

Hi Jerry,

Thanks for your feedback.
I copied the array formula you mentioned.
However, if I enter it it says :

"The formula you entered contains an error"

(I have a Dutch version of Excel, the above message is a translation of the message I get)

I've pressed CTRL+SHIFT+ENTER after I entered the formula

 

[Jerry Sullivan]

Mike,

Maybe if you break this down into steps it will be easier to spot the problem.

The screen shot and formulas below do each of the 3 tests separately.
Note that you'll need to temporarily insert two extra columns between Column I:L to test this out.
So the formula in J23 is referencing Column S which is now the Leg Difference.

Darts2

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 87px"><COL style="WIDTH: 90px"><COL style="WIDTH: 81px"><COL style="WIDTH: 113px"><COL style="WIDTH: 80px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD></TR><TR style="HEIGHT: 95px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Points</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Criterion 1
Points * 100
</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Criterion 2
Legs Diff Rank * 10
</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">TieBreak SubTotal</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Criterion 3
Winner of Match Between any Players with Tied Scores
</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">TieBreak Total</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Final Rank</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">6</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">600</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">10</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">610</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">610</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">500</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">20</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">520</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">520</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">2</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">400</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">30</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">430</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">430</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">5</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">400</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">30</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">430</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">1</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">431</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">400</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">50</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">450</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">450</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff6600; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold">3</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>I23</TD><TD>=SUM(C23:G23)*100</TD></TR><TR><TD>J23</TD><TD>=RANK(S23,S$23:S$27,1)*10</TD></TR><TR><TD>K23</TD><TD>=I23+J23</TD></TR><TR><TD>L23</TD><TD>{=SUM((K$23:K$27=K23)*(TRANSPOSE(C23:G23)=2))}</TD></TR><TR><TD>M23</TD><TD>=K23+L23</TD></TR><TR><TD>N23</TD><TD>=RANK(M23,M$23:M$27,0)</TD></TR></TBODY></TABLE></TD></TR><TR><TD>Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!
</TD></TR></TBODY></TABLE>
Excel tables to the web - Excel Jeanie Html 4


<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[MrTinkertrain]

Hello Jerry,

I've tried your suggestion to break it down into steps and that worked.

Many thanks for your contribution and the detailed explanation

Mike

 

[shanelthiggs]

Hi All

Jerry, I found your solution to the points tiebreaker really useful for something I was recently working on. Although I don't really understand the logic of the whole formula (particularly the transpose element) it did what I needed it to do. I was hoping / wondering if there was any way of adapting this formula to use for other tiebreak situations, i.e. in the OP's example, Leg Difference, where the values are not likely to be static?

Ideally, what I would like to get to with my own 'tournament sheet' (football / soccer) is for the final standings to be ranked / positioned as follows:

Points
If two or more teams are equal on points, then the following criteria is applied:
A) higher number of points obtained in the matches played between the teams in question
B) superior goal difference resulting from the matches played between the teams in question
C) higher number of goals scored in the matches played between the teams in question
If having applied criteria A) to C), there are teams that still have an equal ranking, then criteria A) to C) are re-applied exclusively to the matches played among the teams in question (e.g. the 1st iteration may be between 3 teams, and remove 1 from the equation, leaving the criteria to be re-applied to the remaining 2 teams). If this procedure does not lead to a decision, then the following criteria is applied:
D) superior goal difference in all matches played
E) higher number of goals scored in all matches played
F) fair play conduct in the tournament*
G) position in the national coefficient rankings*

I am comfortable with the ranking, and for applying criteria A), and D) to G), but it's the B) and C) criteria where I'm stumped as to how to formulate because unlike points, they're not static values per match, and need to be re-calculated depending on the teams involved.

As an example, there are four teams (Team 1, Team 2, Team 3, Team 4), who each play once against each other. The results are:
Team 1 vs Team 2 Result: 2-1
Team 3 vs Team 4 Result: 1-2
Team 4 vs Team 2 Result: 1-2
Team 3 vs Team 1 Result: 3-2
Team 4 vs Team 1 Result: 0-0
Team 2 vs Team 3 Result: 1-1
(Win = 3pts, Draw = 1pt, Lose = 0pts)

All teams finish with 4pts, and a goal difference of 0. With the criteria defined, A) would yield no difference, as would B), and C) would give Team 3 an advantage due to scoring more goals (5 vs 4 vs 4 vs 3). Teams 1 & 2 would then be above Team 4 (4 vs 4 vs 3) but are equal to each other, so would enter the 2nd iteration of the criteria. Criteria A) would see Team 1 take the advantage, and so the final standing would be:
1st: Team 3
2nd: Team 1
3rd: Team 2
4th: Team 4

Any suggestions are of course completely welcome. Ideally, I'd like to keep the formulas separate from each other, so B) would be in one cell, and C) in the next. I can worry about combining all criteria into an overall score at a later point.

Many Thanks
Shane

 

[shanelthiggs]

OK, I think I've figured it out but I would appreciate any further comments if anything to validate my logic:

Taking Jerry's formula, which I have used for Criteria A) [points] *I have reduced by one column to account for my four teams:
{=SUM((K$23:K$27=K23)*(TRANSPOSE(C23:F23)=2))}

I have then added the result to my [points] value and stored in M23: K23+L23

In cell N23, I've then used a set of data (for display purposes let's use AC:AF) that contains the 'Goal Difference' values to determine Criteria B):
{=SUM((M$23:M$27=M23)*SUM(TRANSPOSE(AC23:AF23)))}

The result is then added to my earlier total, and stored in O23: M23+N23

In cell P23, I've then used a set of data (for display purposes let's use BC:BF) that contains the 'Goals For' values to determine Criteria C):
{=SUM((O$23:O$27=O23)*SUM(TRANSPOSE(BC23:BF23)))}

The result is then added to the last total, and stored in Q23: O23+P23

I've then re-applied the same process (Points, GD, GF) in the adjacent cells. The final total is made up of:
=([TieBreakTotal]*1000)+([GoalDiffTotal]*100)+([GoalsForTotal]*10)

Of course, the remaining 2 criteria can then easily be fit in around this for the final ranking.

Apologies if this all seems a it sporadic, but I'm hoping I've managed to 'crack the case' so to speak.