Creating a Volleyball League Schedule

docwoody

New Member
Joined
Sep 3, 2007
Messages
31
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.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
I tried it ...
Which "it" are you referring to? There are four suggestions in that link. Your post in the Test here forum does not appear to come from any one of those four suggestions in Fluff's link.

What version of Excel and what operating system are you using?
 
Upvote 0
I tried pasting in the test forum. Unfortunately my work account will not open any of the other links. I have Excel 2010 and it looks like Windows 7 for the OS. What can I say, my bosses do not upgrade much.
 
Upvote 0

Forum statistics

Threads
1,223,710
Messages
6,174,017
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top