Hello,
I'm running a round robin tournament with following table:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody>
[TD="align: center"]Group A[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]MW[/TD]
[TD="align: center"]ML[/TD]
[TD="align: center"]FW[/TD]
[TD="align: center"]FL[/TD]
[TD="align: center"]FD[/TD]
[TD="align: center"]FA[/TD]
[TD="align: center"]POS[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Player 1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0.53[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Player 2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]6[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]0.76[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Player 3[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="bgcolor: #9FC5E8, align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]-1[/TD]
[TD="bgcolor: #B6D7A8, align: center"]0.48[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]Player 4[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #9FC5E8, align: center"]1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]-1[/TD]
[TD="bgcolor: #B6D7A8, align: center"]0.48[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]Player 5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFE599, align: center"]2[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]-4[/TD]
[TD="align: center"]0.39[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]Player 6[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0.56[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]Player 7[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0.53[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]Player 8[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #595959"][/TD]
[TD="bgcolor: #FFE599, align: center"]1[/TD]
[TD="align: center"]8[/TD]
</tbody>
First criteria to pick a group winner is the number of Matches Won (MW), followed by Frame Average (FA). I've managed to do this with a combination of rank.eq- and sumproduct -functions (by watching a video on youtube). POS: (=RANK.EQ(K2,$K$2:$K$9,0)+sumproduct(--(K2=$K$2:$K$9),--(P2<$P$2:$P$9))
What I'd like to know is how to compare the two players' (3 and 4) match result with same Frame Average, and take it into account in the POS-criteria.
As you can see in the POS-column, they both have position 5, which I'd like to solve with the result of their respective encounter, highlighted in blue.
So Player 3 would be No.5 and 4 No.6.
Just curious about this, I can easily check their positions from the table, but this stuck to my mind a bit, and I'd like to know if there's a solution .
Cheers,
Rowboat
I'm running a round robin tournament with following table:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
1 | ||||
6 | 6 | 13 | -7 | 0.32 |
<tbody>
[TD="align: center"]Group A[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]MW[/TD]
[TD="align: center"]ML[/TD]
[TD="align: center"]FW[/TD]
[TD="align: center"]FL[/TD]
[TD="align: center"]FD[/TD]
[TD="align: center"]FA[/TD]
[TD="align: center"]POS[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]Player 1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0.53[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]Player 2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]6[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]0.76[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]Player 3[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="bgcolor: #9FC5E8, align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]-1[/TD]
[TD="bgcolor: #B6D7A8, align: center"]0.48[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]Player 4[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #9FC5E8, align: center"]1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]-1[/TD]
[TD="bgcolor: #B6D7A8, align: center"]0.48[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]Player 5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFE599, align: center"]2[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]-4[/TD]
[TD="align: center"]0.39[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]Player 6[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0.56[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]Player 7[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0.53[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]Player 8[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #595959"][/TD]
[TD="bgcolor: #FFE599, align: center"]1[/TD]
[TD="align: center"]8[/TD]
</tbody>
First criteria to pick a group winner is the number of Matches Won (MW), followed by Frame Average (FA). I've managed to do this with a combination of rank.eq- and sumproduct -functions (by watching a video on youtube). POS: (=RANK.EQ(K2,$K$2:$K$9,0)+sumproduct(--(K2=$K$2:$K$9),--(P2<$P$2:$P$9))
What I'd like to know is how to compare the two players' (3 and 4) match result with same Frame Average, and take it into account in the POS-criteria.
As you can see in the POS-column, they both have position 5, which I'd like to solve with the result of their respective encounter, highlighted in blue.
So Player 3 would be No.5 and 4 No.6.
Just curious about this, I can easily check their positions from the table, but this stuck to my mind a bit, and I'd like to know if there's a solution .
Cheers,
Rowboat