Address |
Formula |
Value |
C3 |
=COUNT(Player0!$A$3:$A$30) |
0 |
D3 |
=COUNT(Player0!$AE$3:$AE$30) |
0 |
E3 |
=C3-D3 |
0 |
F3 |
=SUM(Player0!$AQ$3:$AQ$30) |
0 |
G3 |
=SUM(Player0!$AR$3:$AR$30) |
0 |
H3 |
=SUM(Player0!$AS$3:$AS$30) |
0 |
I3 |
=SUM(Player0!$AT$3:$AT$30) |
0 |
J3 |
=SUM(F3:I3) |
0 |
K3 |
=MAX(Player0!$AE$3:$AE$30) |
0 |
L3 |
=SUM(Player0!$AN$3:$AN$30) |
0 |
M3 |
=SUM(Player0!$AO$3:$AO$30) |
0 |
N3 |
=IF(C3=0,0,MAX(Player0!$AP$3:$AP$30))*3 |
0 |
O3 |
=IF(C3=0,0,MAX(Player0!$AP$3:$AP$30)) |
0 |
P3 |
=IF(C3=0,0,M3/L3) |
0 |
Q3 |
=IF(C3=0,0,D3/C3) |
0 |
C4 |
=COUNT(Player1!$A$3:$A$30) |
1 |
D4 |
=COUNT(Player1!$AE$3:$AE$60) |
1 |
E4 |
=C4-D4 |
0 |
F4 |
=SUM(Player1!$AQ$3:$AQ$60) |
0 |
G4 |
=SUM(Player1!$AR$3:$AR$60) |
0 |
H4 |
=SUM(Player1!$AS$3:$AS$60) |
0 |
I4 |
=SUM(Player1!$AT$3:$AT$60) |
0 |
J4 |
=SUM(F4:I4) |
0 |
K4 |
=MAX(Player1!$AE$3:$AE$60) |
4 |
L4 |
=SUM(Player1!$AN$3:$AN$60) |
65 |
M4 |
=SUM(Player1!$AO$3:$AO$60) |
801 |
N4 |
=IF(C4=0,0,MAX(Player1!$AP$3:$AP$30))*3 |
36.96923077 |
O4 |
=IF(C4=0,0,MAX(Player1!$AP$3:$AP$30)) |
12.32307692 |
P4 |
=IF(C4=0,0,M4/L4) |
12.32307692 |
Q4 |
=IF(C4=0,0,D4/C4) |
1 |
C5 |
=COUNT(Player2!$A$3:$A$30) |
0 |
D5 |
=COUNT(Player2!$AE$3:$AE$60) |
0 |
E5 |
=C5-D5 |
0 |
F5 |
=SUM(Player2!$AQ$3:$AQ$60) |
0 |
G5 |
=SUM(Player2!$AR$3:$AR$60) |
0 |
H5 |
=SUM(Player2!$AS$3:$AS$60) |
0 |
I5 |
=SUM(Player2!$AT$3:$AT$60) |
0 |
J5 |
=SUM(F5:I5) |
0 |
K5 |
=MAX(Player2!$AE$3:$AE$60) |
0 |
L5 |
=SUM(Player2!$AN$3:$AN$60) |
0 |
M5 |
=SUM(Player2!$AO$3:$AO$60) |
0 |
N5 |
=IF(C5=0,0,MAX(Player2!$AP$3:$AP$30))*3 |
0 |
O5 |
=IF(C5=0,0,MAX(Player2!$AP$3:$AP$30)) |
0 |
P5 |
=IF(C5=0,0,M5/L5) |
0 |
Q5 |
=IF(C5=0,0,D5/C5) |
0 |
C6 |
=COUNT(Player3!$A$3:$A$30) |
0 |
D6 |
=COUNT(Player3!$AE$3:$AE$60) |
0 |
E6 |
=C6-D6 |
0 |
F6 |
=SUM(Player3!$AQ$3:$AQ$60) |
0 |
G6 |
=SUM(Player3!$AR$3:$AR$60) |
0 |
H6 |
=SUM(Player3!$AS$3:$AS$60) |
0 |
I6 |
=SUM(Player3!$AT$3:$AT$60) |
0 |
J6 |
=SUM(F6:I6) |
0 |
K6 |
=MAX(Player3!$AE$3:$AE$60) |
0 |
L6 |
=SUM(Player3!$AN$3:$AN$60) |
0 |
M6 |
=SUM(Player3!$AO$3:$AO$60) |
0 |
N6 |
=IF(C6=0,0,MAX(Player3!$AP$3:$AP$30))*3 |
0 |
O6 |
=IF(C6=0,0,MAX(Player3!$AP$3:$AP$30)) |
0 |
P6 |
=IF(C6=0,0,M6/L6) |
0 |
Q6 |
=IF(C6=0,0,D6/C6) |
0 |
C7 |
=COUNT(Player4!$A$3:$A$30) |
0 |
D7 |
=COUNT(Player4!$AE$3:$AE$60) |
0 |
E7 |
=C7-D7 |
0 |
F7 |
=SUM(Player4!$AQ$3:$AQ$61) |
0 |
G7 |
=SUM(Player4!$AR$3:$AR$61) |
0 |
H7 |
=SUM(Player4!$AS$3:$AS$61) |
0 |
I7 |
=SUM(Player4!$AT$3:$AT$61) |
0 |
J7 |
=SUM(F7:I7) |
0 |
K7 |
=MAX(Player4!$AE$3:$AE$61) |
0 |
L7 |
=SUM(Player4!$AN$3:$AN$61) |
0 |
M7 |
=SUM(Player4!$AO$3:$AO$61) |
0 |
N7 |
=IF(C7=0,0,MAX(Player4!$AP$3:$AP$30))*3 |
0 |
O7 |
=IF(C7=0,0,MAX(Player4!$AP$3:$AP$30)) |
0 |
P7 |
=IF(C7=0,0,M7/L7) |
0 |
Q7 |
=IF(C7=0,0,D7/C7) |
0 |
C8 |
=COUNT(Player5!$A$3:$A$30) |
0 |
D8 |
=COUNT(Player5!$AE$3:$AE$60) |
0 |
E8 |
=C8-D8 |
0 |
F8 |
=SUM(Player5!$AQ$3:$AQ$60) |
0 |
G8 |
=SUM(Player5!$AR$3:$AR$60) |
0 |
H8 |
=SUM(Player5!$AS$3:$AS$60) |
0 |
I8 |
=SUM(Player5!$AT$3:$AT$60) |
0 |
J8 |
=SUM(F8:I8) |
0 |
K8 |
=MAX(Player5!$AE$3:$AE$60) |
0 |
L8 |
=SUM(Player5!$AN$3:$AN$60) |
0 |
M8 |
=SUM(Player5!$AO$3:$AO$60) |
0 |
N8 |
=IF(C8=0,0,MAX(Player5!$AP$3:$AP$30))*3 |
0 |
O8 |
=IF(C8=0,0,MAX(Player5!$AP$3:$AP$30)) |
0 |
P8 |
=IF(C8=0,0,M8/L8) |
0 |
Q8 |
=IF(C8=0,0,D8/C8) |
0 |
C9 |
=COUNT(Player6!$A$3:$A$30) |
0 |
D9 |
=COUNT(Player6!$AE$3:$AE$60) |
0 |
E9 |
=C9-D9 |
0 |
F9 |
=SUM(Player6!$AQ$3:$AQ$60) |
0 |
G9 |
=SUM(Player6!$AR$3:$AR$60) |
0 |
H9 |
=SUM(Player6!$AS$3:$AS$60) |
0 |
I9 |
=SUM(Player6!$AT$3:$AT$60) |
0 |
J9 |
=SUM(F9:I9) |
0 |
K9 |
=MAX(Player6!$AE$3:$AE$60) |
0 |
L9 |
=SUM(Player6!$AN$3:$AN$60) |
0 |
M9 |
=SUM(Player6!$AO$3:$AO$60) |
0 |
N9 |
=IF(C9=0,0,MAX(Player6!$AP$3:$AP$30))*3 |
0 |
O9 |
=IF(C9=0,0,MAX(Player6!$AP$3:$AP$30)) |
0 |
P9 |
=IF(C9=0,0,M9/L9) |
0 |
Q9 |
=IF(C9=0,0,D9/C9) |
0 |
C10 |
=COUNT(Player7!$A$3:$A$30) |
0 |
D10 |
=COUNT(Player7!$AE$3:$AE$30) |
0 |
E10 |
=C10-D10 |
0 |
F10 |
=SUM(Player7!$AQ$3:$AQ$30) |
0 |
G10 |
=SUM(Player7!$AR$3:$AR$30) |
0 |
H10 |
=SUM(Player7!$AS$3:$AS$30) |
0 |
I10 |
=SUM(Player7!$AT$3:$AT$30) |
0 |
J10 |
=SUM(F10:I10) |
0 |
K10 |
=MAX(Player7!$AE$3:$AE$30) |
0 |
L10 |
=SUM(Player7!$AN$3:$AN$30) |
0 |
M10 |
=SUM(Player7!$AO$3:$AO$30) |
0 |
N10 |
=IF(C10=0,0,MAX(Player7!$AP$3:$AP$30))*3 |
0 |
O10 |
=IF(C10=0,0,MAX(Player7!$AP$3:$AP$30)) |
0 |
P10 |
=IF(C10=0,0,M10/L10) |
0 |
Q10 |
=IF(C10=0,0,D10/C10) |
0 |
C11 |
=COUNT(Player8!$A$3:$A$30) |
0 |
D11 |
=COUNT(Player8!$AE$3:$AE$62) |
0 |
E11 |
=C11-D11 |
0 |
F11 |
=SUM(Player8!$AQ$3:$AQ$62) |
0 |
G11 |
=SUM(Player8!$AR$3:$AR$62) |
0 |
H11 |
=SUM(Player8!$AS$3:$AS$62) |
0 |
I11 |
=SUM(Player8!$AT$3:$AT$62) |
0 |
J11 |
=SUM(F11:I11) |
0 |
K11 |
=MAX(Player8!$AE$3:$AE$62) |
0 |
L11 |
=SUM(Player8!$AN$3:$AN$62) |
0 |
M11 |
=SUM(Player8!$AO$3:$AO$30) |
0 |
N11 |
=IF(C11=0,0,MAX(Player8!$AP$3:$AP$30))*3 |
0 |
O11 |
=IF(C11=0,0,MAX(Player8!$AP$3:$AP$30)) |
0 |
P11 |
=IF(C11=0,0,M11/L11) |
0 |
Q11 |
=IF(C11=0,0,D11/C11) |
0 |
C12 |
=COUNT(Player9!$A$3:$A$30) |
0 |
D12 |
=COUNT(Player9!$AE$3:$AE$62) |
0 |
E12 |
=C12-D12 |
0 |
F12 |
=SUM(Player9!$AQ$3:$AQ$62) |
0 |
G12 |
=SUM(Player9!$AR$3:$AR$62) |
0 |
H12 |
=SUM(Player9!$AS$3:$AS$62) |
0 |
I12 |
=SUM(Player9!$AT$3:$AT$62) |
0 |
J12 |
=SUM(F12:I12) |
0 |
K12 |
=MAX(Player9!$AE$3:$AE$62) |
0 |
L12 |
=SUM(Player9!$AN$3:$AN$62) |
0 |
M12 |
=SUM(Player9!$AO$3:$AO$30) |
0 |
N12 |
=IF(C12=0,0,MAX(Player9!$AP$3:$AP$30))*3 |
0 |
O12 |
=IF(C12=0,0,MAX(Player9!$AP$3:$AP$30)) |
0 |
P12 |
=IF(C12=0,0,M12/L12) |
0 |
Q12 |
=IF(C12=0,0,D12/C12) |
0 |
C13 |
=COUNT(Player10!$A$3:$A$30) |
0 |
D13 |
=COUNT(Player10!$AE$3:$AE$62) |
0 |
E13 |
=C13-D13 |
0 |
F13 |
=SUM(Player10!$AQ$3:$AQ$62) |
0 |
G13 |
=SUM(Player10!$AR$3:$AR$62) |
0 |
H13 |
=SUM(Player10!$AS$3:$AS$62) |
0 |
I13 |
=SUM(Player10!$AT$3:$AT$62) |
0 |
J13 |
=SUM(F13:I13) |
0 |
K13 |
=MAX(Player10!$AE$3:$AE$62) |
0 |
L13 |
=SUM(Player10!$AN$3:$AN$62) |
0 |
M13 |
=SUM(Player10!$AO$3:$AO$30) |
0 |
N13 |
=IF(C13=0,0,MAX(Player10!$AP$3:$AP$30))*3 |
0 |
O13 |
=IF(C13=0,0,MAX(Player10!$AP$3:$AP$30)) |
0 |
P13 |
=IF(C13=0,0,M13/L13) |
0 |
Q13 |
=IF(C13=0,0,D13/C13) |
0 |
C14 |
=COUNT(Player11!$A$3:$A$30) |
0 |
D14 |
=COUNT(Player11!$AE$3:$AE$62) |
0 |
E14 |
=C14-D14 |
0 |
F14 |
=SUM(Player11!$AQ$3:$AQ$62) |
0 |
G14 |
=SUM(Player11!$AR$3:$AR$62) |
0 |
H14 |
=SUM(Player11!$AS$3:$AS$62) |
0 |
I14 |
=SUM(Player11!$AT$3:$AT$62) |
0 |
J14 |
=SUM(F14:I14) |
0 |
K14 |
=MAX(Player11!$AE$3:$AE$62) |
0 |
L14 |
=SUM(Player11!$AN$3:$AN$62) |
0 |
M14 |
=SUM(Player11!$AO$3:$AO$30) |
0 |
N14 |
=IF(C14=0,0,MAX(Player11!$AP$3:$AP$30))*3 |
0 |
O14 |
=IF(C14=0,0,MAX(Player11!$AP$3:$AP$30)) |
0 |
P14 |
=IF(C14=0,0,M14/L14) |
0 |
Q14 |
=IF(C14=0,0,D14/C14) |
0 |
C15 |
=COUNT(Player12!$A$3:$A$30) |
0 |
D15 |
=COUNT(Player12!$AE$3:$AE$62) |
0 |
E15 |
=C15-D15 |
0 |
F15 |
=SUM(Player12!$AQ$3:$AQ$62) |
0 |
G15 |
=SUM(Player12!$AR$3:$AR$62) |
0 |
H15 |
=SUM(Player12!$AS$3:$AS$62) |
0 |
I15 |
=SUM(Player12!$AT$3:$AT$62) |
0 |
J15 |
=SUM(F15:I15) |
0 |
K15 |
=MAX(Player12!$AE$3:$AE$62) |
0 |
L15 |
=SUM(Player12!$AN$3:$AN$62) |
0 |
M15 |
=SUM(Player12!$AO$3:$AO$30) |
0 |
N15 |
=IF(C15=0,0,MAX(Player12!$AP$3:$AP$30))*3 |
0 |
O15 |
=IF(C15=0,0,MAX(Player12!$AP$3:$AP$30)) |
0 |
P15 |
=IF(C15=0,0,M15/L15) |
0 |
Q15 |
=IF(C15=0,0,D15/C15) |
0 |
C16 |
=COUNT(Player13!$A$3:$A$30) |
0 |
D16 |
=COUNT(Player13!$AE$3:$AE$62) |
0 |
E16 |
=C16-D16 |
0 |
F16 |
=SUM(Player13!$AQ$3:$AQ$62) |
0 |
G16 |
=SUM(Player13!$AR$3:$AR$62) |
0 |
H16 |
=SUM(Player13!$AS$3:$AS$62) |
0 |
I16 |
=SUM(Player13!$AT$3:$AT$62) |
0 |
J16 |
=SUM(F16:I16) |
0 |
K16 |
=MAX(Player13!$AE$3:$AE$62) |
0 |
L16 |
=SUM(Player13!$AN$3:$AN$62) |
0 |
M16 |
=SUM(Player13!$AO$3:$AO$30) |
0 |
N16 |
=IF(C16=0,0,MAX(Player13!$AP$3:$AP$30))*3 |
0 |
O16 |
=IF(C16=0,0,MAX(Player13!$AP$3:$AP$30)) |
0 |
P16 |
=IF(C16=0,0,M16/L16) |
0 |
Q16 |
=IF(C16=0,0,D16/C16) |
0 |
C17 |
=COUNT(Player14!$A$3:$A$30) |
0 |
D17 |
=COUNT(Player14!$AE$3:$AE$62) |
0 |
E17 |
=C17-D17 |
0 |
F17 |
=SUM(Player14!$AQ$3:$AQ$62) |
0 |
G17 |
=SUM(Player14!$AR$3:$AR$62) |
0 |
H17 |
=SUM(Player14!$AS$3:$AS$62) |
0 |
I17 |
=SUM(Player14!$AT$3:$AT$62) |
0 |
J17 |
=SUM(F17:I17) |
0 |
K17 |
=MAX(Player14!$AE$3:$AE$62) |
0 |
L17 |
=SUM(Player14!$AN$3:$AN$62) |
0 |
M17 |
=SUM(Player14!$AO$3:$AO$30) |
0 |
N17 |
=IF(C17=0,0,MAX(Player14!$AP$3:$AP$30))*3 |
0 |
O17 |
=IF(C17=0,0,MAX(Player14!$AP$3:$AP$30)) |
0 |
P17 |
=IF(C17=0,0,M17/L17) |
0 |
Q17 |
=IF(C17=0,0,D17/C17) |
0 |
C18 |
=COUNT(Player15!$A$3:$A$30) |
0 |
D18 |
=COUNT(Player15!$AE$3:$AE$62) |
0 |
E18 |
=C18-D18 |
0 |
F18 |
=SUM(Player15!$AQ$3:$AQ$62) |
0 |
G18 |
=SUM(Player15!$AR$3:$AR$62) |
0 |
H18 |
=SUM(Player15!$AS$3:$AS$62) |
0 |
I18 |
=SUM(Player15!$AT$3:$AT$62) |
0 |
J18 |
=SUM(F18:I18) |
0 |
K18 |
=MAX(Player15!$AE$3:$AE$62) |
0 |
L18 |
=SUM(Player15!$AN$3:$AN$62) |
0 |
M18 |
=SUM(Player15!$AO$3:$AO$30) |
0 |
N18 |
=IF(C18=0,0,MAX(Player15!$AP$3:$AP$30))*3 |
0 |
O18 |
=IF(C18=0,0,MAX(Player15!$AP$3:$AP$30)) |
0 |
P18 |
=IF(C18=0,0,M18/L18) |
0 |
Q18 |
=IF(C18=0,0,D18/C18) |
0 |
C19 |
=COUNT(Player16!$A$3:$A$30) |
0 |
D19 |
=COUNT(Player16!$AE$3:$AE$62) |
0 |
E19 |
=C19-D19 |
0 |
F19 |
=SUM(Player16!$AQ$3:$AQ$62) |
0 |
G19 |
=SUM(Player16!$AR$3:$AR$62) |
0 |
H19 |
=SUM(Player16!$AS$3:$AS$62) |
0 |
I19 |
=SUM(Player16!$AT$3:$AT$62) |
0 |
J19 |
=SUM(F19:I19) |
0 |
K19 |
=MAX(Player16!$AE$3:$AE$62) |
0 |
L19 |
=SUM(Player16!$AN$3:$AN$62) |
0 |
M19 |
=SUM(Player16!$AO$3:$AO$30) |
0 |
N19 |
=IF(C19=0,0,MAX(Player16!$AP$3:$AP$30))*3 |
0 |
O19 |
=IF(C19=0,0,MAX(Player16!$AP$3:$AP$30)) |
0 |
P19 |
=IF(C19=0,0,M19/L19) |
0 |
Q19 |
=IF(C19=0,0,D19/C19) |
0 |
C20 |
=COUNT(Player17!$A$3:$A$30) |
0 |
D20 |
=COUNT(Player17!$AE$3:$AE$62) |
0 |
E20 |
=C20-D20 |
0 |
F20 |
=SUM(Player17!$AQ$3:$AQ$62) |
0 |
G20 |
=SUM(Player17!$AR$3:$AR$62) |
0 |
H20 |
=SUM(Player17!$AS$3:$AS$62) |
0 |
I20 |
=SUM(Player17!$AT$3:$AT$62) |
0 |
J20 |
=SUM(F20:I20) |
0 |
K20 |
=MAX(Player17!$AE$3:$AE$62) |
0 |
L20 |
=SUM(Player17!$AN$3:$AN$62) |
0 |
M20 |
=SUM(Player17!$AO$3:$AO$30) |
0 |
N20 |
=IF(C20=0,0,MAX(Player17!$AP$3:$AP$30))*3 |
0 |
O20 |
=IF(C20=0,0,MAX(Player17!$AP$3:$AP$30)) |
0 |
P20 |
=IF(C20=0,0,M20/L20) |
0 |
Q20 |
=IF(C20=0,0,D20/C20) |
0 |
C21 |
=COUNT(Player18!$A$3:$A$30) |
0 |
D21 |
=COUNT(Player18!$AE$3:$AE$62) |
0 |
E21 |
=C21-D21 |
0 |
F21 |
=SUM(Player18!$AQ$3:$AQ$62) |
0 |
G21 |
=SUM(Player18!$AR$3:$AR$62) |
0 |
H21 |
=SUM(Player18!$AS$3:$AS$62) |
0 |
I21 |
=SUM(Player18!$AT$3:$AT$62) |
0 |
J21 |
=SUM(F21:I21) |
0 |
K21 |
=MAX(Player18!$AE$3:$AE$62) |
0 |
L21 |
=SUM(Player18!$AN$3:$AN$62) |
0 |
M21 |
=SUM(Player18!$AO$3:$AO$30) |
0 |
N21 |
=IF(C21=0,0,MAX(Player18!$AP$3:$AP$30))*3 |
0 |
O21 |
=IF(C21=0,0,MAX(Player18!$AP$3:$AP$30)) |
0 |
P21 |
=IF(C21=0,0,M21/L21) |
0 |
Q21 |
=IF(C21=0,0,D21/C21) |
0 |
C22 |
=COUNT(Player19!$A$3:$A$30) |
0 |
D22 |
=COUNT(Player19!$AE$3:$AE$62) |
0 |
E22 |
=C22-D22 |
0 |
F22 |
=SUM(Player19!$AQ$3:$AQ$62) |
0 |
G22 |
=SUM(Player19!$AR$3:$AR$62) |
0 |
H22 |
=SUM(Player19!$AS$3:$AS$62) |
0 |
I22 |
=SUM(Player19!$AT$3:$AT$62) |
0 |
J22 |
=SUM(F22:I22) |
0 |
K22 |
=MAX(Player19!$AE$3:$AE$62) |
0 |
L22 |
=SUM(Player19!$AN$3:$AN$62) |
0 |
M22 |
=SUM(Player19!$AO$3:$AO$30) |
0 |
N22 |
=IF(C22=0,0,MAX(Player19!$AP$3:$AP$30))*3 |
0 |
O22 |
=IF(C22=0,0,MAX(Player19!$AP$3:$AP$30)) |
0 |
P22 |
=IF(C22=0,0,M22/L22) |
0 |
Q22 |
=IF(C22=0,0,D22/C22) |
0 |
C23 |
=COUNT(Player20!$A$3:$A$30) |
0 |
D23 |
=COUNT(Player20!$AE$3:$AE$62) |
0 |
E23 |
=C23-D23 |
0 |
F23 |
=SUM(Player20!$AQ$3:$AQ$62) |
0 |
G23 |
=SUM(Player20!$AR$3:$AR$62) |
0 |
H23 |
=SUM(Player20!$AS$3:$AS$62) |
0 |
I23 |
=SUM(Player20!$AT$3:$AT$62) |
0 |
J23 |
=SUM(F23:I23) |
0 |
K23 |
=MAX(Player20!$AE$3:$AE$62) |
0 |
L23 |
=SUM(Player20!$AN$3:$AN$62) |
0 |
M23 |
=SUM(Player20!$AO$3:$AO$30) |
0 |
N23 |
=IF(C23=0,0,MAX(Player20!$AP$3:$AP$30))*3 |
0 |
O23 |
=IF(C23=0,0,MAX(Player20!$AP$3:$AP$30)) |
0 |
P23 |
=IF(C23=0,0,M23/L23) |
0 |
Q23 |
=IF(C23=0,0,D23/C23) |
0 |
C24 |
=COUNT(Player21!$A$3:$A$30) |
0 |
D24 |
=COUNT(Player21!$AE$3:$AE$62) |
0 |
E24 |
=C24-D24 |
0 |
F24 |
=SUM(Player21!$AQ$3:$AQ$62) |
0 |
G24 |
=SUM(Player21!$AR$3:$AR$62) |
0 |
H24 |
=SUM(Player21!$AS$3:$AS$62) |
0 |
I24 |
=SUM(Player21!$AT$3:$AT$62) |
0 |
J24 |
=SUM(F24:I24) |
0 |
K24 |
=MAX(Player21!$AE$3:$AE$62) |
0 |
L24 |
=SUM(Player21!$AN$3:$AN$62) |
0 |
M24 |
=SUM(Player21!$AO$3:$AO$30) |
0 |
N24 |
=IF(C24=0,0,MAX(Player21!$AP$3:$AP$30))*3 |
0 |
O24 |
=IF(C24=0,0,MAX(Player21!$AP$3:$AP$30)) |
0 |
P24 |
=IF(C24=0,0,M24/L24) |
0 |
Q24 |
=IF(C24=0,0,D24/C24) |
0 |
C25 |
=COUNT(Player22!$A$3:$A$30) |
0 |
D25 |
=COUNT(Player22!$AE$3:$AE$62) |
0 |
E25 |
=C25-D25 |
0 |
F25 |
=SUM(Player22!$AQ$3:$AQ$62) |
0 |
G25 |
=SUM(Player22!$AR$3:$AR$62) |
0 |
H25 |
=SUM(Player22!$AS$3:$AS$62) |
0 |
I25 |
=SUM(Player22!$AT$3:$AT$62) |
0 |
J25 |
=SUM(F25:I25) |
0 |
K25 |
=MAX(Player22!$AE$3:$AE$62) |
0 |
L25 |
=SUM(Player22!$AN$3:$AN$62) |
0 |
M25 |
=SUM(Player22!$AO$3:$AO$30) |
0 |
N25 |
=IF(C25=0,0,MAX(Player22!$AP$3:$AP$30))*3 |
0 |
O25 |
=IF(C25=0,0,MAX(Player22!$AP$3:$AP$30)) |
0 |
P25 |
=IF(C25=0,0,M25/L25) |
0 |
Q25 |
=IF(C25=0,0,D25/C25) |
0 |
C26 |
=COUNT(Player23!$A$3:$A$30) |
0 |
D26 |
=COUNT(Player23!$AE$3:$AE$62) |
0 |
E26 |
=C26-D26 |
0 |
F26 |
=SUM(Player23!$AQ$3:$AQ$62) |
0 |
G26 |
=SUM(Player23!$AR$3:$AR$62) |
0 |
H26 |
=SUM(Player23!$AS$3:$AS$62) |
0 |
I26 |
=SUM(Player23!$AT$3:$AT$62) |
0 |
J26 |
=SUM(F26:I26) |
0 |
K26 |
=MAX(Player23!$AE$3:$AE$62) |
0 |
L26 |
=SUM(Player23!$AN$3:$AN$62) |
0 |
M26 |
=SUM(Player23!$AO$3:$AO$30) |
0 |
N26 |
=IF(C26=0,0,MAX(Player23!$AP$3:$AP$30))*3 |
0 |
O26 |
=IF(C26=0,0,MAX(Player23!$AP$3:$AP$30)) |
0 |
P26 |
=IF(C26=0,0,M26/L26) |
0 |
Q26 |
=IF(C26=0,0,D26/C26) |
0 |
C27 |
=COUNT(Player24!$A$3:$A$30) |
0 |
D27 |
=COUNT(Player24!$AE$3:$AE$62) |
0 |
E27 |
=C27-D27 |
0 |
F27 |
=SUM(Player24!$AQ$3:$AQ$62) |
0 |
G27 |
=SUM(Player24!$AR$3:$AR$62) |
0 |
H27 |
=SUM(Player24!$AS$3:$AS$62) |
0 |
I27 |
=SUM(Player24!$AT$3:$AT$62) |
0 |
J27 |
=SUM(F27:I27) |
0 |
K27 |
=MAX(Player24!$AE$3:$AE$62) |
0 |
L27 |
=SUM(Player24!$AN$3:$AN$62) |
0 |
M27 |
=SUM(Player24!$AO$3:$AO$30) |
0 |
N27 |
=IF(C27=0,0,MAX(Player24!$AP$3:$AP$30))*3 |
0 |
O27 |
=IF(C27=0,0,MAX(Player24!$AP$3:$AP$30)) |
0 |
P27 |
=IF(C27=0,0,M27/L27) |
0 |
Q27 |
=IF(C27=0,0,D27/C27) |
0 |
C28 |
=COUNT(Player25!$A$3:$A$30) |
0 |
D28 |
=COUNT(Player25!$AE$3:$AE$62) |
0 |
E28 |
=C28-D28 |
0 |
F28 |
=SUM(Player25!$AQ$3:$AQ$62) |
0 |
G28 |
=SUM(Player25!$AR$3:$AR$62) |
0 |
H28 |
=SUM(Player25!$AS$3:$AS$62) |
0 |
I28 |
=SUM(Player25!$AT$3:$AT$62) |
0 |
J28 |
=SUM(F28:I28) |
0 |
K28 |
=MAX(Player25!$AE$3:$AE$62) |
0 |
L28 |
=SUM(Player25!$AN$3:$AN$62) |
0 |
M28 |
=SUM(Player25!$AO$3:$AO$30) |
0 |
N28 |
=IF(C28=0,0,MAX(Player25!$AP$3:$AP$30))*3 |
0 |
O28 |
=IF(C28=0,0,MAX(Player25!$AP$3:$AP$30)) |
0 |
P28 |
=IF(C28=0,0,M28/L28) |
0 |
Q28 |
=IF(C28=0,0,D28/C28) |
0 |
C29 |
=COUNT(Player26!$A$3:$A$30) |
0 |
D29 |
=COUNT(Player26!$AE$3:$AE$62) |
0 |
E29 |
=C29-D29 |
0 |
F29 |
=SUM(Player26!$AQ$3:$AQ$62) |
0 |
G29 |
=SUM(Player26!$AR$3:$AR$62) |
0 |
H29 |
=SUM(Player26!$AS$3:$AS$62) |
0 |
I29 |
=SUM(Player26!$AT$3:$AT$62) |
0 |
J29 |
=SUM(F29:I29) |
0 |
K29 |
=MAX(Player26!$AE$3:$AE$62) |
0 |
L29 |
=SUM(Player26!$AN$3:$AN$62) |
0 |
M29 |
=SUM(Player26!$AO$3:$AO$30) |
0 |
N29 |
=IF(C29=0,0,MAX(Player26!$AP$3:$AP$30))*3 |
0 |
O29 |
=IF(C29=0,0,MAX(Player26!$AP$3:$AP$30)) |
0 |
P29 |
=IF(C29=0,0,M29/L29) |
0 |
Q29 |
=IF(C29=0,0,D29/C29) |
0 |
C31 |
=SUM(C3:C29) |
1 |
D31 |
=SUM(D3:D29) |
1 |
E31 |
=SUM(E3:E29) |
0 |
F31 |
=SUM(F3:F29) |
0 |
G31 |
=SUM(G3:G29) |
0 |
H31 |
=SUM(H3:H29) |
0 |
I31 |
=SUM(I3:I29) |
0 |
J31 |
=SUM(J3:J29) |
0 |
K31 |
=MAX(K3:K29) |
4 |
L31 |
=SUM(L3:L29) |
65 |
M31 |
=SUM(M3:M29) |
801 |
N31 |
=AVERAGE(N3:N29) |
1.369230769 |
O31 |
=MAX(O3:O29) |
12.32307692 |
P31 |
=IF(C31=0,0,M31/L31) |
12.32307692 |
Q31 |
=IF(C31=0,0,D31/C31) |
1 |
C40 |
=MIN(IF(Player0!$AO$3:$AO$60=801,Player0!$AN$3:$AN$60)) |
0 |
D40 |
=IF(C40=0,0,INDEX(Player0!$AE$3:$AE$60,MATCH(C40,Player0!$AN$3:$AN$60,0))) |
0 |
E40 |
=IF(ISERROR(D40),"",(IF(D40=0,"",C40))) |
|
F40 |
=IF(ISERROR(D40),"",(IF(D40=0,"",IF(E40=$E$67,B40,"")))) |
|
C41 |
=MIN(IF(Player1!$AO$3:$AO$60=801,Player1!$AN$3:$AN$60)) |
65 |
D41 |
=IF(C41=0,0,INDEX(Player1!$AE$3:$AE$60,MATCH(C41,Player1!$AN$3:$AN$60,0))) |
4 |
E41 |
=IF(ISERROR(D41),"",(IF(D41=0,"",C41))) |
65 |
F41 |
=IF(ISERROR(D41),"",(IF(D41=0,"",IF(E41=$E$67,B41,"")))) |
Tom Dick Harry |
C42 |
=MIN(IF(Player2!$AO$3:$AO$60=801,Player2!$AN$3:$AN$60)) |
0 |
D42 |
=IF(C42=0,0,INDEX(Player2!$AE$3:$AE$60,MATCH(C42,Player2!$AN$3:$AN$60,0))) |
0 |
E42 |
=IF(ISERROR(D42),"",(IF(D42=0,"",C42))) |
|
F42 |
=IF(ISERROR(D42),"",(IF(D42=0,"",IF(E42=$E$67,B42,"")))) |
|
C43 |
=MIN(IF(Player3!$AO$3:$AO$60=801,Player3!$AN$3:$AN$60)) |
0 |
D43 |
=IF(C43=0,0,INDEX(Player3!$AE$3:$AE$60,MATCH(C43,Player3!$AN$3:$AN$60,0))) |
0 |
E43 |
=IF(ISERROR(D43),"",(IF(D43=0,"",C43))) |
|
F43 |
=IF(ISERROR(D43),"",(IF(D43=0,"",IF(E43=$E$67,B43,"")))) |
|
C44 |
=MIN(IF(Player4!$AO$3:$AO$60=801,Player4!$AN$3:$AN$60)) |
0 |
D44 |
=IF(C44=0,0,INDEX(Player4!$AE$3:$AE$60,MATCH(C44,Player4!$AN$3:$AN$60,0))) |
0 |
E44 |
=IF(ISERROR(D44),"",(IF(D44=0,"",C44))) |
|
F44 |
=IF(ISERROR(D44),"",(IF(D44=0,"",IF(E44=$E$67,B44,"")))) |
|
C45 |
=MIN(IF(Player5!$AO$3:$AO$60=801,Player5!$AN$3:$AN$60)) |
0 |
D45 |
=IF(C45=0,0,INDEX(Player5!$AE$3:$AE$60,MATCH(C45,Player5!$AN$3:$AN$60,0))) |
0 |
E45 |
=IF(ISERROR(D45),"",(IF(D45=0,"",C45))) |
|
F45 |
=IF(ISERROR(D45),"",(IF(D45=0,"",IF(E45=$E$67,B45,"")))) |
|
C46 |
=MIN(IF(Player6!$AO$3:$AO$60=801,Player6!$AN$3:$AN$60)) |
0 |
D46 |
=IF(C46=0,0,INDEX(Player6!$AE$3:$AE$60,MATCH(C46,Player6!$AN$3:$AN$60,0))) |
0 |
E46 |
=IF(ISERROR(D46),"",(IF(D46=0,"",C46))) |
|
F46 |
=IF(ISERROR(D46),"",(IF(D46=0,"",IF(E46=$E$67,B46,"")))) |
|
C47 |
=MIN(IF(Player7!$AO$3:$AO$60=801,Player7!$AN$3:$AN$60)) |
0 |
D47 |
=IF(C47=0,0,INDEX(Player7!$AE$3:$AE$60,MATCH(C47,Player7!$AN$3:$AN$60,0))) |
0 |
E47 |
=IF(ISERROR(D47),"",(IF(D47=0,"",C47))) |
|
F47 |
=IF(ISERROR(D47),"",(IF(D47=0,"",IF(E47=$E$67,B47,"")))) |
|
C48 |
=MIN(IF(Player8!$AO$3:$AO$60=801,Player8!$AN$3:$AN$60)) |
0 |
D48 |
=IF(C48=0,0,INDEX(Player8!$AE$3:$AE$60,MATCH(C48,Player8!$AN$3:$AN$60,0))) |
0 |
E48 |
=IF(ISERROR(D48),"",(IF(D48=0,"",C48))) |
|
F48 |
=IF(ISERROR(D48),"",(IF(D48=0,"",IF(E48=$E$67,B48,"")))) |
|
C49 |
=MIN(IF(Player9!$AO$3:$AO$60=801,Player9!$AN$3:$AN$60)) |
0 |
D49 |
=IF(C49=0,0,INDEX(Player9!$AE$3:$AE$60,MATCH(C49,Player9!$AN$3:$AN$60,0))) |
0 |
E49 |
=IF(ISERROR(D49),"",(IF(D49=0,"",C49))) |
|
F49 |
=IF(ISERROR(D49),"",(IF(D49=0,"",IF(E49=$E$67,B49,"")))) |
|
C50 |
=MIN(IF(Player10!$AO$3:$AO$60=801,Player10!$AN$3:$AN$60)) |
0 |
D50 |
=IF(C50=0,0,INDEX(Player10!$AE$3:$AE$60,MATCH(C50,Player10!$AN$3:$AN$60,0))) |
0 |
E50 |
=IF(ISERROR(D50),"",(IF(D50=0,"",C50))) |
|
F50 |
=IF(ISERROR(D50),"",(IF(D50=0,"",IF(E50=$E$67,B50,"")))) |
|
C51 |
=MIN(IF(Player11!$AO$3:$AO$60=801,Player11!$AN$3:$AN$60)) |
0 |
D51 |
=IF(C51=0,0,INDEX(Player11!$AE$3:$AE$60,MATCH(C51,Player11!$AN$3:$AN$60,0))) |
0 |
E51 |
=IF(ISERROR(D51),"",(IF(D51=0,"",C51))) |
|
F51 |
=IF(ISERROR(D51),"",(IF(D51=0,"",IF(E51=$E$67,B51,"")))) |
|
C52 |
=MIN(IF(Player12!$AO$3:$AO$60=801,Player12!$AN$3:$AN$60)) |
0 |
D52 |
=IF(C52=0,0,INDEX(Player12!$AE$3:$AE$60,MATCH(C52,Player12!$AN$3:$AN$60,0))) |
0 |
E52 |
=IF(ISERROR(D52),"",(IF(D52=0,"",C52))) |
|
F52 |
=IF(ISERROR(D52),"",(IF(D52=0,"",IF(E52=$E$67,B52,"")))) |
|
C53 |
=MIN(IF(Player13!$AO$3:$AO$60=801,Player13!$AN$3:$AN$60)) |
0 |
D53 |
=IF(C53=0,0,INDEX(Player13!$AE$3:$AE$60,MATCH(C53,Player13!$AN$3:$AN$60,0))) |
0 |
E53 |
=IF(ISERROR(D53),"",(IF(D53=0,"",C53))) |
|
F53 |
=IF(ISERROR(D53),"",(IF(D53=0,"",IF(E53=$E$67,B53,"")))) |
|
C54 |
=MIN(IF(Player14!$AO$3:$AO$60=801,Player14!$AN$3:$AN$60)) |
0 |
D54 |
=IF(C54=0,0,INDEX(Player14!$AE$3:$AE$60,MATCH(C54,Player14!$AN$3:$AN$60,0))) |
0 |
E54 |
=IF(ISERROR(D54),"",(IF(D54=0,"",C54))) |
|
F54 |
=IF(ISERROR(D54),"",(IF(D54=0,"",IF(E54=$E$67,B54,"")))) |
|
C55 |
=MIN(IF(Player15!$AO$3:$AO$60=801,Player15!$AN$3:$AN$60)) |
0 |
D55 |
=IF(C55=0,0,INDEX(Player15!$AE$3:$AE$60,MATCH(C55,Player15!$AN$3:$AN$60,0))) |
0 |
E55 |
=IF(ISERROR(D55),"",(IF(D55=0,"",C55))) |
|
F55 |
=IF(ISERROR(D55),"",(IF(D55=0,"",IF(E55=$E$67,B55,"")))) |
|
C56 |
=MIN(IF(Player16!$AO$3:$AO$60=801,Player16!$AN$3:$AN$60)) |
0 |
D56 |
=IF(C56=0,0,INDEX(Player16!$AE$3:$AE$60,MATCH(C56,Player16!$AN$3:$AN$60,0))) |
0 |
E56 |
=IF(ISERROR(D56),"",(IF(D56=0,"",C56))) |
|
F56 |
=IF(ISERROR(D56),"",(IF(D56=0,"",IF(E56=$E$67,B56,"")))) |
|
C57 |
=MIN(IF(Player17!$AO$3:$AO$60=801,Player17!$AN$3:$AN$60)) |
0 |
D57 |
=IF(C57=0,0,INDEX(Player17!$AE$3:$AE$60,MATCH(C57,Player17!$AN$3:$AN$60,0))) |
0 |
E57 |
=IF(ISERROR(D57),"",(IF(D57=0,"",C57))) |
|
F57 |
=IF(ISERROR(D57),"",(IF(D57=0,"",IF(E57=$E$67,B57,"")))) |
|
C58 |
=MIN(IF(Player18!$AO$3:$AO$60=801,Player18!$AN$3:$AN$60)) |
0 |
D58 |
=IF(C58=0,0,INDEX(Player18!$AE$3:$AE$60,MATCH(C58,Player18!$AN$3:$AN$60,0))) |
0 |
E58 |
=IF(ISERROR(D58),"",(IF(D58=0,"",C58))) |
|
F58 |
=IF(ISERROR(D58),"",(IF(D58=0,"",IF(E58=$E$67,B58,"")))) |
|
C59 |
=MIN(IF(Player19!$AO$3:$AO$60=801,Player19!$AN$3:$AN$60)) |
0 |
D59 |
=IF(C59=0,0,INDEX(Player19!$AE$3:$AE$60,MATCH(C59,Player19!$AN$3:$AN$60,0))) |
0 |
E59 |
=IF(ISERROR(D59),"",(IF(D59=0,"",C59))) |
|
F59 |
=IF(ISERROR(D59),"",(IF(D59=0,"",IF(E59=$E$67,B59,"")))) |
|
C60 |
=MIN(IF(Player20!$AO$3:$AO$60=801,Player20!$AN$3:$AN$60)) |
0 |
D60 |
=IF(C60=0,0,INDEX(Player20!$AE$3:$AE$60,MATCH(C60,Player20!$AN$3:$AN$60,0))) |
0 |
E60 |
=IF(ISERROR(D60),"",(IF(D60=0,"",C60))) |
|
F60 |
=IF(ISERROR(D60),"",(IF(D60=0,"",IF(E60=$E$67,B60,"")))) |
|
C61 |
=MIN(IF(Player21!$AO$3:$AO$60=801,Player21!$AN$3:$AN$60)) |
0 |
D61 |
=IF(C61=0,0,INDEX(Player21!$AE$3:$AE$60,MATCH(C61,Player21!$AN$3:$AN$60,0))) |
0 |
E61 |
=IF(ISERROR(D61),"",(IF(D61=0,"",C61))) |
|
F61 |
=IF(ISERROR(D61),"",(IF(D61=0,"",IF(E61=$E$67,B61,"")))) |
|
C62 |
=MIN(IF(Player22!$AO$3:$AO$60=801,Player22!$AN$3:$AN$60)) |
0 |
D62 |
=IF(C62=0,0,INDEX(Player22!$AE$3:$AE$60,MATCH(C62,Player22!$AN$3:$AN$60,0))) |
0 |
E62 |
=IF(ISERROR(D62),"",(IF(D62=0,"",C62))) |
|
F62 |
=IF(ISERROR(D62),"",(IF(D62=0,"",IF(E62=$E$67,B62,"")))) |
|
C63 |
=MIN(IF(Player23!$AO$3:$AO$60=801,Player23!$AN$3:$AN$60)) |
0 |
D63 |
=IF(C63=0,0,INDEX(Player23!$AE$3:$AE$60,MATCH(C63,Player23!$AN$3:$AN$60,0))) |
0 |
E63 |
=IF(ISERROR(D63),"",(IF(D63=0,"",C63))) |
|
F63 |
=IF(ISERROR(D63),"",(IF(D63=0,"",IF(E63=$E$67,B63,"")))) |
|
C64 |
=MIN(IF(Player24!$AO$3:$AO$60=801,Player24!$AN$3:$AN$60)) |
0 |
D64 |
=IF(C64=0,0,INDEX(Player24!$AE$3:$AE$60,MATCH(C64,Player24!$AN$3:$AN$60,0))) |
0 |
E64 |
=IF(ISERROR(D64),"",(IF(D64=0,"",C64))) |
|
F64 |
=IF(ISERROR(D64),"",(IF(D64=0,"",IF(E64=$E$67,B64,"")))) |
|
C65 |
=MIN(IF(Player25!$AO$3:$AO$60=801,Player25!$AN$3:$AN$60)) |
0 |
D65 |
=IF(C65=0,0,INDEX(Player25!$AE$3:$AE$60,MATCH(C65,Player25!$AN$3:$AN$60,0))) |
0 |
E65 |
=IF(ISERROR(D65),"",(IF(D65=0,"",C65))) |
|
F65 |
=IF(ISERROR(D65),"",(IF(D65=0,"",IF(E65=$E$67,B65,"")))) |
|
C66 |
=MIN(IF(Player26!$AO$3:$AO$60=801,Player26!$AN$3:$AN$60)) |
0 |
D66 |
=IF(C66=0,0,INDEX(Player26!$AE$3:$AE$60,MATCH(C66,Player26!$AN$3:$AN$60,0))) |
0 |
E66 |
=IF(ISERROR(D66),"",(IF(D66=0,"",C66))) |
|
F66 |
=IF(ISERROR(D66),"",(IF(D66=0,"",IF(E66=$E$67,B66,"")))) |
|
C67 |
=MIN(IF(C40:C66<>0,C40:C66)) |
65 |
D67 |
=VLOOKUP(C67,C40:D66,2,FALSE) |
4 |
E67 |
=MIN(IF(E40:E66<>0,E40:E66)) |
65 |
F67 |
=INDEX(F40:F66,MATCH(TRUE,LEN(F40:F66)<>0,0),1) |
Tom Dick Harry |
K40 |
=MAX(Player0!$AN$3:$AN$30) |
0 |
L40 |
=IF(ISERROR(INDEX(Player0!$AE$3:$AE$30,MATCH(MAX(Player0!$AN$3:$AN$30),Player0!$AN$3:$AN$30,0))),"-",(INDEX(Player0!$AE$3:$AE$30,MATCH(MAX(Player0!$AN$3:$AN$30),Player0!$AN$3:$AN$30,0)))) |
- |
M40 |
=IF(ISERROR(FontColor(INDEX(Player0!$AE$3:$AE$30,MATCH(MAX(Player0!$AN$3:$AN$30),Player0!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player0!$AE$3:$AE$30,MATCH(MAX(Player0!$AN$3:$AN$30),Player0!$AN$3:$AN$30,0)),TRUE))) |
- |
N40 |
=IF(M40="Red",H40,IF(M40="Green",I40,IF(M40="Blue",J40,IF(M40="No
color","Lost",IF(M40<" ","-"))))) |
- |
K41 |
=MAX(Player1!$AN$3:$AN$30) |
65 |
L41 |
=IF(ISERROR(INDEX(Player1!$AE$3:$AE$30,MATCH(MAX(Player1!$AN$3:$AN$30),Player1!$AN$3:$AN$30,0))),"-",(INDEX(Player1!$AE$3:$AE$30,MATCH(MAX(Player1!$AN$3:$AN$30),Player1!$AN$3:$AN$30,0)))) |
4 |
M41 |
=IF(ISERROR(FontColor(INDEX(Player1!$AE$3:$AE$30,MATCH(MAX(Player1!$AN$3:$AN$30),Player1!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player1!$AE$3:$AE$30,MATCH(MAX(Player1!$AN$3:$AN$30),Player1!$AN$3:$AN$30,0)),TRUE))) |
Blue |
N41 |
=IF(M41="Red",H41,IF(M41="Green",I41,IF(M41="Blue",J41,IF(M41="No
color","Lost",IF(M41<" ","-"))))) |
Harry |
K42 |
=MAX(Player2!$AN$3:$AN$30) |
0 |
L42 |
=IF(ISERROR(INDEX(Player2!$AE$3:$AE$30,MATCH(MAX(Player2!$AN$3:$AN$30),Player2!$AN$3:$AN$30,0))),"-",(INDEX(Player2!$AE$3:$AE$30,MATCH(MAX(Player2!$AN$3:$AN$30),Player2!$AN$3:$AN$30,0)))) |
- |
M42 |
=IF(ISERROR(FontColor(INDEX(Player2!$AE$3:$AE$30,MATCH(MAX(Player2!$AN$3:$AN$30),Player2!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player2!$AE$3:$AE$30,MATCH(MAX(Player2!$AN$3:$AN$30),Player2!$AN$3:$AN$30,0)),TRUE))) |
- |
N42 |
=IF(M42="Red",H42,IF(M42="Green",I42,IF(M42="Blue",J42,IF(M42="No
color","Lost",IF(M42<" ","-"))))) |
- |
K43 |
=MAX(Player3!$AN$3:$AN$30) |
0 |
L43 |
=IF(ISERROR(INDEX(Player3!$AE$3:$AE$30,MATCH(MAX(Player3!$AN$3:$AN$30),Player3!$AN$3:$AN$30,0))),"-",(INDEX(Player3!$AE$3:$AE$30,MATCH(MAX(Player3!$AN$3:$AN$30),Player3!$AN$3:$AN$30,0)))) |
- |
M43 |
=IF(ISERROR(FontColor(INDEX(Player3!$AE$3:$AE$30,MATCH(MAX(Player3!$AN$3:$AN$30),Player3!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player3!$AE$3:$AE$30,MATCH(MAX(Player3!$AN$3:$AN$30),Player3!$AN$3:$AN$30,0)),TRUE))) |
- |
N43 |
=IF(M43="Red",H43,IF(M43="Green",I43,IF(M43="Blue",J43,IF(M43="No
color","Lost",IF(M43<" ","-"))))) |
- |
K44 |
=MAX(Player4!$AN$3:$AN$30) |
0 |
L44 |
=IF(ISERROR(INDEX(Player4!$AE$3:$AE$30,MATCH(MAX(Player4!$AN$3:$AN$30),Player4!$AN$3:$AN$30,0))),"-",(INDEX(Player4!$AE$3:$AE$30,MATCH(MAX(Player4!$AN$3:$AN$30),Player4!$AN$3:$AN$30,0)))) |
- |
M44 |
=IF(ISERROR(FontColor(INDEX(Player4!$AE$3:$AE$30,MATCH(MAX(Player4!$AN$3:$AN$30),Player4!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player4!$AE$3:$AE$30,MATCH(MAX(Player4!$AN$3:$AN$30),Player4!$AN$3:$AN$30,0)),TRUE))) |
- |
N44 |
=IF(M44="Red",H44,IF(M44="Green",I44,IF(M44="Blue",J44,IF(M44="No
color","Lost",IF(M44<" ","-"))))) |
- |
K45 |
=MAX(Player5!$AN$3:$AN$30) |
0 |
L45 |
=IF(ISERROR(INDEX(Player5!$AE$3:$AE$30,MATCH(MAX(Player5!$AN$3:$AN$30),Player5!$AN$3:$AN$30,0))),"-",(INDEX(Player5!$AE$3:$AE$30,MATCH(MAX(Player5!$AN$3:$AN$30),Player5!$AN$3:$AN$30,0)))) |
- |
M45 |
=IF(ISERROR(FontColor(INDEX(Player5!$AE$3:$AE$30,MATCH(MAX(Player5!$AN$3:$AN$30),Player5!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player5!$AE$3:$AE$30,MATCH(MAX(Player5!$AN$3:$AN$30),Player5!$AN$3:$AN$30,0)),TRUE))) |
- |
N45 |
=IF(M45="Red",H45,IF(M45="Green",I45,IF(M45="Blue",J45,IF(M45="No
color","Lost",IF(M45<" ","-"))))) |
- |
K46 |
=MAX(Player6!$AN$3:$AN$30) |
0 |
L46 |
=IF(ISERROR(INDEX(Player6!$AE$3:$AE$30,MATCH(MAX(Player6!$AN$3:$AN$30),Player6!$AN$3:$AN$30,0))),"-",(INDEX(Player6!$AE$3:$AE$30,MATCH(MAX(Player6!$AN$3:$AN$30),Player6!$AN$3:$AN$30,0)))) |
- |
M46 |
=IF(ISERROR(FontColor(INDEX(Player6!$AE$3:$AE$30,MATCH(MAX(Player6!$AN$3:$AN$30),Player6!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player6!$AE$3:$AE$30,MATCH(MAX(Player6!$AN$3:$AN$30),Player6!$AN$3:$AN$30,0)),TRUE))) |
- |
N46 |
=IF(M46="Red",H46,IF(M46="Green",I46,IF(M46="Blue",J46,IF(M46="No
color","Lost",IF(M46<" ","-"))))) |
- |
K47 |
=MAX(Player7!$AN$3:$AN$30) |
0 |
L47 |
=IF(ISERROR(INDEX(Playe7!$AE$3:$AE$30,MATCH(MAX(Playe7!$AN$3:$AN$30),Playe7!$AN$3:$AN$30,0))),"-",(INDEX(Playe7!$AE$3:$AE$30,MATCH(MAX(Playe7!$AN$3:$AN$30),Playe7!$AN$3:$AN$30,0)))) |
- |
M47 |
=IF(ISERROR(FontColor(INDEX(Playe7!$AE$3:$AE$30,MATCH(MAX(Playe7!$AN$3:$AN$30),Playe7!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Playe7!$AE$3:$AE$30,MATCH(MAX(Playe7!$AN$3:$AN$30),Playe7!$AN$3:$AN$30,0)),TRUE))) |
- |
N47 |
=IF(M47="Red",H47,IF(M47="Green",I47,IF(M47="Blue",J47,IF(M47="No
color","Lost",IF(M47<" ","-"))))) |
- |
K48 |
=MAX(Player8!$AN$3:$AN$30) |
0 |
L48 |
=IF(ISERROR(INDEX(Player8!$AE$3:$AE$30,MATCH(MAX(Player8!$AN$3:$AN$30),Player8!$AN$3:$AN$30,0))),"-",(INDEX(Player8!$AE$3:$AE$30,MATCH(MAX(Player8!$AN$3:$AN$30),Player8!$AN$3:$AN$30,0)))) |
- |
M48 |
=IF(ISERROR(FontColor(INDEX(Player8!$AE$3:$AE$30,MATCH(MAX(Player8!$AN$3:$AN$30),Player8!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player8!$AE$3:$AE$30,MATCH(MAX(Player8!$AN$3:$AN$30),Player8!$AN$3:$AN$30,0)),TRUE))) |
- |
N48 |
=IF(M48="Red",H48,IF(M48="Green",I48,IF(M48="Blue",J48,IF(M48="No
color","Lost",IF(M48<" ","-"))))) |
- |
K49 |
=MAX(Player9!$AN$3:$AN$30) |
0 |
L49 |
=IF(ISERROR(INDEX(Player9!$AE$3:$AE$30,MATCH(MAX(Player9!$AN$3:$AN$30),Player9!$AN$3:$AN$30,0))),"-",(INDEX(Player9!$AE$3:$AE$30,MATCH(MAX(Player9!$AN$3:$AN$30),Player9!$AN$3:$AN$30,0)))) |
- |
M49 |
=IF(ISERROR(FontColor(INDEX(Player9!$AE$3:$AE$30,MATCH(MAX(Player9!$AN$3:$AN$30),Player9!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player9!$AE$3:$AE$30,MATCH(MAX(Player9!$AN$3:$AN$30),Player9!$AN$3:$AN$30,0)),TRUE))) |
- |
N49 |
=IF(M49="Red",H49,IF(M49="Green",I49,IF(M49="Blue",J49,IF(M49="No
color","Lost",IF(M49<" ","-"))))) |
- |
K50 |
=MAX(Player10!$AN$3:$AN$30) |
0 |
L50 |
=IF(ISERROR(INDEX(Player10!$AE$3:$AE$30,MATCH(MAX(Player10!$AN$3:$AN$30),Player10!$AN$3:$AN$30,0))),"-",(INDEX(Player10!$AE$3:$AE$30,MATCH(MAX(Player10!$AN$3:$AN$30),Player10!$AN$3:$AN$30,0)))) |
- |
M50 |
=IF(ISERROR(FontColor(INDEX(Player10!$AE$3:$AE$30,MATCH(MAX(Player10!$AN$3:$AN$30),Player10!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player10!$AE$3:$AE$30,MATCH(MAX(Player10!$AN$3:$AN$30),Player10!$AN$3:$AN$30,0)),TRUE))) |
- |
N50 |
=IF(M50="Red",H50,IF(M50="Green",I50,IF(M50="Blue",J50,IF(M50="No
color","Lost",IF(M50<" ","-"))))) |
- |
K51 |
=MAX(Player11!$AN$3:$AN$30) |
0 |
L51 |
=IF(ISERROR(INDEX(Player11!$AE$3:$AE$30,MATCH(MAX(Player11!$AN$3:$AN$30),Player11!$AN$3:$AN$30,0))),"-",(INDEX(Player11!$AE$3:$AE$30,MATCH(MAX(Player11!$AN$3:$AN$30),Player11!$AN$3:$AN$30,0)))) |
- |
M51 |
=IF(ISERROR(FontColor(INDEX(Player11!$AE$3:$AE$30,MATCH(MAX(Player11!$AN$3:$AN$30),Player11!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player11!$AE$3:$AE$30,MATCH(MAX(Player11!$AN$3:$AN$30),Player11!$AN$3:$AN$30,0)),TRUE))) |
- |
N51 |
=IF(M51="Red",H51,IF(M51="Green",I51,IF(M51="Blue",J51,IF(M51="No
color","Lost",IF(M51<" ","-"))))) |
- |
K52 |
=MAX(Player12!$AN$3:$AN$30) |
0 |
L52 |
=IF(ISERROR(INDEX(Player12!$AE$3:$AE$30,MATCH(MAX(Player12!$AN$3:$AN$30),Player12!$AN$3:$AN$30,0))),"-",(INDEX(Player12!$AE$3:$AE$30,MATCH(MAX(Player12!$AN$3:$AN$30),Player12!$AN$3:$AN$30,0)))) |
- |
M52 |
=IF(ISERROR(FontColor(INDEX(Player12!$AE$3:$AE$30,MATCH(MAX(Player12!$AN$3:$AN$30),Player12!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player12!$AE$3:$AE$30,MATCH(MAX(Player12!$AN$3:$AN$30),Player12!$AN$3:$AN$30,0)),TRUE))) |
- |
N52 |
=IF(M52="Red",H52,IF(M52="Green",I52,IF(M52="Blue",J52,IF(M52="No
color","Lost",IF(M52<" ","-"))))) |
- |
K53 |
=MAX(Player13!$AN$3:$AN$30) |
0 |
L53 |
=IF(ISERROR(INDEX(Player13!$AE$3:$AE$30,MATCH(MAX(Player13!$AN$3:$AN$30),Player13!$AN$3:$AN$30,0))),"-",(INDEX(Player13!$AE$3:$AE$30,MATCH(MAX(Player13!$AN$3:$AN$30),Player13!$AN$3:$AN$30,0)))) |
- |
M53 |
=IF(ISERROR(FontColor(INDEX(Player13!$AE$3:$AE$30,MATCH(MAX(Player13!$AN$3:$AN$30),Player13!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player13!$AE$3:$AE$30,MATCH(MAX(Player13!$AN$3:$AN$30),Player13!$AN$3:$AN$30,0)),TRUE))) |
- |
N53 |
=IF(M53="Red",H53,IF(M53="Green",I53,IF(M53="Blue",J53,IF(M53="No
color","Lost",IF(M53<" ","-"))))) |
- |
K54 |
=MAX(Player14!$AN$3:$AN$30) |
0 |
L54 |
=IF(ISERROR(INDEX(Player14!$AE$3:$AE$30,MATCH(MAX(Player14!$AN$3:$AN$30),Player14!$AN$3:$AN$30,0))),"-",(INDEX(Player14!$AE$3:$AE$30,MATCH(MAX(Player14!$AN$3:$AN$30),Player14!$AN$3:$AN$30,0)))) |
- |
M54 |
=IF(ISERROR(FontColor(INDEX(Player14!$AE$3:$AE$30,MATCH(MAX(Player14!$AN$3:$AN$30),Player14!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player14!$AE$3:$AE$30,MATCH(MAX(Player14!$AN$3:$AN$30),Player14!$AN$3:$AN$30,0)),TRUE))) |
- |
N54 |
=IF(M54="Red",H54,IF(M54="Green",I54,IF(M54="Blue",J54,IF(M54="No
color","Lost",IF(M54<" ","-"))))) |
- |
K55 |
=MAX(Player15!$AN$3:$AN$30) |
0 |
L55 |
=IF(ISERROR(INDEX(Player15!$AE$3:$AE$30,MATCH(MAX(Player15!$AN$3:$AN$30),Player15!$AN$3:$AN$30,0))),"-",(INDEX(Player15!$AE$3:$AE$30,MATCH(MAX(Player15!$AN$3:$AN$30),Player15!$AN$3:$AN$30,0)))) |
- |
M55 |
=IF(ISERROR(FontColor(INDEX(Player15!$AE$3:$AE$30,MATCH(MAX(Player15!$AN$3:$AN$30),Player15!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player15!$AE$3:$AE$30,MATCH(MAX(Player15!$AN$3:$AN$30),Player15!$AN$3:$AN$30,0)),TRUE))) |
- |
N55 |
=IF(M55="Red",H55,IF(M55="Green",I55,IF(M55="Blue",J55,IF(M55="No
color","Lost",IF(M55<" ","-"))))) |
- |
K56 |
=MAX(Player16!$AN$3:$AN$30) |
0 |
L56 |
=IF(ISERROR(INDEX(Player16!$AE$3:$AE$30,MATCH(MAX(Player16!$AN$3:$AN$30),Player16!$AN$3:$AN$30,0))),"-",(INDEX(Player16!$AE$3:$AE$30,MATCH(MAX(Player16!$AN$3:$AN$30),Player16!$AN$3:$AN$30,0)))) |
- |
M56 |
=IF(ISERROR(FontColor(INDEX(Player16!$AE$3:$AE$30,MATCH(MAX(Player16!$AN$3:$AN$30),Player16!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player16!$AE$3:$AE$30,MATCH(MAX(Player16!$AN$3:$AN$30),Player16!$AN$3:$AN$30,0)),TRUE))) |
- |
N56 |
=IF(M56="Red",H56,IF(M56="Green",I56,IF(M56="Blue",J56,IF(M56="No
color","Lost",IF(M56<" ","-"))))) |
- |
K57 |
=MAX(Player17!$AN$3:$AN$30) |
0 |
L57 |
=IF(ISERROR(INDEX(Player17!$AE$3:$AE$30,MATCH(MAX(Player17!$AN$3:$AN$30),Player17!$AN$3:$AN$30,0))),"-",(INDEX(Player17!$AE$3:$AE$30,MATCH(MAX(Player17!$AN$3:$AN$30),Player17!$AN$3:$AN$30,0)))) |
- |
M57 |
=IF(ISERROR(FontColor(INDEX(Player17!$AE$3:$AE$30,MATCH(MAX(Player17!$AN$3:$AN$30),Player17!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player17!$AE$3:$AE$30,MATCH(MAX(Player17!$AN$3:$AN$30),Player17!$AN$3:$AN$30,0)),TRUE))) |
- |
N57 |
=IF(M57="Red",H57,IF(M57="Green",I57,IF(M57="Blue",J57,IF(M57="No
color","Lost",IF(M57<" ","-"))))) |
- |
K58 |
=MAX(Player18!$AN$3:$AN$30) |
0 |
L58 |
=IF(ISERROR(INDEX(Player18!$AE$3:$AE$30,MATCH(MAX(Player18!$AN$3:$AN$30),Player18!$AN$3:$AN$30,0))),"-",(INDEX(Player18!$AE$3:$AE$30,MATCH(MAX(Player18!$AN$3:$AN$30),Player18!$AN$3:$AN$30,0)))) |
- |
M58 |
=IF(ISERROR(FontColor(INDEX(Player18!$AE$3:$AE$30,MATCH(MAX(Player18!$AN$3:$AN$30),Player18!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player18!$AE$3:$AE$30,MATCH(MAX(Player18!$AN$3:$AN$30),Player18!$AN$3:$AN$30,0)),TRUE))) |
- |
N58 |
=IF(M58="Red",H58,IF(M58="Green",I58,IF(M58="Blue",J58,IF(M58="No
color","Lost",IF(M58<" ","-"))))) |
- |
K59 |
=MAX(Player19!$AN$3:$AN$30) |
0 |
L59 |
=IF(ISERROR(INDEX(Player19!$AE$3:$AE$30,MATCH(MAX(Player19!$AN$3:$AN$30),Player19!$AN$3:$AN$30,0))),"-",(INDEX(Player19!$AE$3:$AE$30,MATCH(MAX(Player19!$AN$3:$AN$30),Player19!$AN$3:$AN$30,0)))) |
- |
M59 |
=IF(ISERROR(FontColor(INDEX(Player19!$AE$3:$AE$30,MATCH(MAX(Player19!$AN$3:$AN$30),Player19!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player19!$AE$3:$AE$30,MATCH(MAX(Player19!$AN$3:$AN$30),Player19!$AN$3:$AN$30,0)),TRUE))) |
- |
N59 |
=IF(M59="Red",H59,IF(M59="Green",I59,IF(M59="Blue",J59,IF(M59="No
color","Lost",IF(M59<" ","-"))))) |
- |
K60 |
=MAX(Player20!$AN$3:$AN$30) |
0 |
L60 |
=IF(ISERROR(INDEX(Player20!$AE$3:$AE$30,MATCH(MAX(Player20!$AN$3:$AN$30),Player20!$AN$3:$AN$30,0))),"-",(INDEX(Player20!$AE$3:$AE$30,MATCH(MAX(Player20!$AN$3:$AN$30),Player20!$AN$3:$AN$30,0)))) |
- |
M60 |
=IF(ISERROR(FontColor(INDEX(Player20!$AE$3:$AE$30,MATCH(MAX(Player20!$AN$3:$AN$30),Player20!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player20!$AE$3:$AE$30,MATCH(MAX(Player20!$AN$3:$AN$30),Player20!$AN$3:$AN$30,0)),TRUE))) |
- |
N60 |
=IF(M60="Red",H60,IF(M60="Green",I60,IF(M60="Blue",J60,IF(M60="No
color","Lost",IF(M60<" ","-"))))) |
- |
K61 |
=MAX(Player21!$AN$3:$AN$30) |
0 |
L61 |
=IF(ISERROR(INDEX(Player21!$AE$3:$AE$30,MATCH(MAX(Player21!$AN$3:$AN$30),Player21!$AN$3:$AN$30,0))),"-",(INDEX(Player21!$AE$3:$AE$30,MATCH(MAX(Player21!$AN$3:$AN$30),Player21!$AN$3:$AN$30,0)))) |
- |
M61 |
=IF(ISERROR(FontColor(INDEX(Player21!$AE$3:$AE$30,MATCH(MAX(Player21!$AN$3:$AN$30),Player21!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player21!$AE$3:$AE$30,MATCH(MAX(Player21!$AN$3:$AN$30),Player21!$AN$3:$AN$30,0)),TRUE))) |
- |
N61 |
=IF(M61="Red",H61,IF(M61="Green",I61,IF(M61="Blue",J61,IF(M61="No
color","Lost",IF(M61<" ","-"))))) |
- |
K62 |
=MAX(Player22!$AN$3:$AN$30) |
0 |
L62 |
=IF(ISERROR(INDEX(Player22!$AE$3:$AE$30,MATCH(MAX(Player22!$AN$3:$AN$30),Player22!$AN$3:$AN$30,0))),"-",(INDEX(Player22!$AE$3:$AE$30,MATCH(MAX(Player22!$AN$3:$AN$30),Player22!$AN$3:$AN$30,0)))) |
- |
M62 |
=IF(ISERROR(FontColor(INDEX(Player22!$AE$3:$AE$30,MATCH(MAX(Player22!$AN$3:$AN$30),Player22!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player22!$AE$3:$AE$30,MATCH(MAX(Player22!$AN$3:$AN$30),Player22!$AN$3:$AN$30,0)),TRUE))) |
- |
N62 |
=IF(M62="Red",H62,IF(M62="Green",I62,IF(M62="Blue",J62,IF(M62="No
color","Lost",IF(M62<" ","-"))))) |
- |
K63 |
=MAX(Player23!$AN$3:$AN$30) |
0 |
L63 |
=IF(ISERROR(INDEX(Player23!$AE$3:$AE$30,MATCH(MAX(Player23!$AN$3:$AN$30),Player23!$AN$3:$AN$30,0))),"-",(INDEX(Player23!$AE$3:$AE$30,MATCH(MAX(Player23!$AN$3:$AN$30),Player23!$AN$3:$AN$30,0)))) |
- |
M63 |
=IF(ISERROR(FontColor(INDEX(Player23!$AE$3:$AE$30,MATCH(MAX(Player23!$AN$3:$AN$30),Player23!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player23!$AE$3:$AE$30,MATCH(MAX(Player23!$AN$3:$AN$30),Player23!$AN$3:$AN$30,0)),TRUE))) |
- |
N63 |
=IF(M63="Red",H63,IF(M63="Green",I63,IF(M63="Blue",J63,IF(M63="No
color","Lost",IF(M63<" ","-"))))) |
- |
K64 |
=MAX(Player24!$AN$3:$AN$30) |
0 |
L64 |
=IF(ISERROR(INDEX(Player24!$AE$3:$AE$30,MATCH(MAX(Player24!$AN$3:$AN$30),Player24!$AN$3:$AN$30,0))),"-",(INDEX(Player24!$AE$3:$AE$30,MATCH(MAX(Player24!$AN$3:$AN$30),Player24!$AN$3:$AN$30,0)))) |
- |
M64 |
=IF(ISERROR(FontColor(INDEX(Player24!$AE$3:$AE$30,MATCH(MAX(Player24!$AN$3:$AN$30),Player24!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player24!$AE$3:$AE$30,MATCH(MAX(Player24!$AN$3:$AN$30),Player24!$AN$3:$AN$30,0)),TRUE))) |
- |
N64 |
=IF(M64="Red",H64,IF(M64="Green",I64,IF(M64="Blue",J64,IF(M64="No
color","Lost",IF(M64<" ","-"))))) |
- |
K65 |
=MAX(Player25!$AN$3:$AN$30) |
0 |
L65 |
=IF(ISERROR(INDEX(Player25!$AE$3:$AE$30,MATCH(MAX(Player25!$AN$3:$AN$30),Player25!$AN$3:$AN$30,0))),"-",(INDEX(Player25!$AE$3:$AE$30,MATCH(MAX(Player25!$AN$3:$AN$30),Player25!$AN$3:$AN$30,0)))) |
- |
M65 |
=IF(ISERROR(FontColor(INDEX(Player25!$AE$3:$AE$30,MATCH(MAX(Player25!$AN$3:$AN$30),Player25!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player25!$AE$3:$AE$30,MATCH(MAX(Player25!$AN$3:$AN$30),Player25!$AN$3:$AN$30,0)),TRUE))) |
- |
N65 |
=IF(M65="Red",H65,IF(M65="Green",I65,IF(M65="Blue",J65,IF(M65="No
color","Lost",IF(M65<" ","-"))))) |
- |
K66 |
=MAX(Player26!$AN$3:$AN$30) |
0 |
L66 |
=IF(ISERROR(INDEX(Player26!$AE$3:$AE$30,MATCH(MAX(Player26!$AN$3:$AN$30),Player26!$AN$3:$AN$30,0))),"-",(INDEX(Player26!$AE$3:$AE$30,MATCH(MAX(Player26!$AN$3:$AN$30),Player26!$AN$3:$AN$30,0)))) |
- |
M66 |
=IF(ISERROR(FontColor(INDEX(Player26!$AE$3:$AE$30,MATCH(MAX(Player26!$AN$3:$AN$30),Player26!$AN$3:$AN$30,0)),TRUE)),"-",(FontColor(INDEX(Player26!$AE$3:$AE$30,MATCH(MAX(Player26!$AN$3:$AN$30),Player26!$AN$3:$AN$30,0)),TRUE))) |
- |
N66 |
=IF(M66="Red",H66,IF(M66="Green",I66,IF(M66="Blue",J66,IF(M66="No
color","Lost",IF(M66<" ","-"))))) |
- |
K67 |
=MAX(K40:K66) |
65 |
L67 |
=VLOOKUP(K67,K40:L66,2,FALSE) |
4 |
M67 |
=VLOOKUP(K67,K40:M66,3,FALSE) |
Blue |
N67 |
=VLOOKUP(L67,L40:N66,3,FALSE) |
Harry |
|
|
|