Hello experts,
I am trying to create a volleyball league schedule on excel where I can place scores(I14:I17, K14:K17, Q14:Q17, S14:S17) that automatically calculate and update the cells that show the standings (E2:E9, F2:F9).
A B C D E F G H I J K L M N O P Q R S T
1 Captains Teams Wins Loses
2 Andrew Wookiees 4 0
3 Courtney Sith Lords 3 1
4 Vasilios Tie Fighters 3 1
5 Genevieve Tusken Raiders 2 2
6 Cezar Storm Troopers 2 2
7 Leslie Jedi Knights 1 3
8 Mikayla X-Wing Fighters 1 3
9 Paul Ewoks 0 4
10
11 Court I Court II
12 Results Results
13 27-Sep Week 1 HT Home Team vs VT Visiting Team HT VT HT HomeTeam vs VT Visiting Team HT VT
14 6:30PM 7:15PM Tie Fighters 25 25 Ewoks 18 10 2 - 0 X-Wing Fighters 25 20 Tusken Raiders 20 25 1 - 1
15 7:15PM 8:00PM Tie Fighters 20 27 Jedi Knights 25 25 1 - 1 X-Wing Fighters 23 19 Sith Lords 25 25 2 - 0
16 8:00PM 8:45PM Wookiees 25 25 Ewoks 10 10 2 - 0 Storm Troopers 25 18 Tusken Raiders 22 25 1 - 1
17 8:45PM 9:30PM Wookiees 25 26 Jedi Knights 23 16 2 - 0 Storm Troopers 25 24 Sith Lords 22 26 1 - 1
Is this possible to do? Thank you in advance for your help.
Respectfully,
DocWoody
My sample does not transfer very well.
So team names are C1:C9, wins are E1 :E9 and loses F1 : F9. Teams show playing against each other will be court I home teams C14 : C17 and visiting teams F14 : F17. For court II home teams L14 : L17 and visiting teams O14 : O17. The results of the matches will be placed as court I home team wins I14 : I17 and home team loses K14 : K17. For the visiting team wins K14 : K17 and for loses I14 : I17. For court II, the home team wins will be R14 : R17 and the loses T14 : T17. For the visiting team wins T14 : T17 and for the loses R14 : R17. I need to somehow correlate the team names with the wins and loses to E1 : E9 and F1 : F9.
I am trying to create a volleyball league schedule on excel where I can place scores(I14:I17, K14:K17, Q14:Q17, S14:S17) that automatically calculate and update the cells that show the standings (E2:E9, F2:F9).
A B C D E F G H I J K L M N O P Q R S T
1 Captains Teams Wins Loses
2 Andrew Wookiees 4 0
3 Courtney Sith Lords 3 1
4 Vasilios Tie Fighters 3 1
5 Genevieve Tusken Raiders 2 2
6 Cezar Storm Troopers 2 2
7 Leslie Jedi Knights 1 3
8 Mikayla X-Wing Fighters 1 3
9 Paul Ewoks 0 4
10
11 Court I Court II
12 Results Results
13 27-Sep Week 1 HT Home Team vs VT Visiting Team HT VT HT HomeTeam vs VT Visiting Team HT VT
14 6:30PM 7:15PM Tie Fighters 25 25 Ewoks 18 10 2 - 0 X-Wing Fighters 25 20 Tusken Raiders 20 25 1 - 1
15 7:15PM 8:00PM Tie Fighters 20 27 Jedi Knights 25 25 1 - 1 X-Wing Fighters 23 19 Sith Lords 25 25 2 - 0
16 8:00PM 8:45PM Wookiees 25 25 Ewoks 10 10 2 - 0 Storm Troopers 25 18 Tusken Raiders 22 25 1 - 1
17 8:45PM 9:30PM Wookiees 25 26 Jedi Knights 23 16 2 - 0 Storm Troopers 25 24 Sith Lords 22 26 1 - 1
Is this possible to do? Thank you in advance for your help.
Respectfully,
DocWoody
My sample does not transfer very well.
So team names are C1:C9, wins are E1 :E9 and loses F1 : F9. Teams show playing against each other will be court I home teams C14 : C17 and visiting teams F14 : F17. For court II home teams L14 : L17 and visiting teams O14 : O17. The results of the matches will be placed as court I home team wins I14 : I17 and home team loses K14 : K17. For the visiting team wins K14 : K17 and for loses I14 : I17. For court II, the home team wins will be R14 : R17 and the loses T14 : T17. For the visiting team wins T14 : T17 and for the loses R14 : R17. I need to somehow correlate the team names with the wins and loses to E1 : E9 and F1 : F9.