Creating a Volleyball League Schedule

[docwoody]

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.

 

[Fluff]

you can find some tools here https://www.mrexcel.com/forum/about-board/508133-attachments.html
That will allow you to post data to the board & keep the format.

 

[docwoody]

Thanks Fluff, I tried it and the same issue happened with the data scrambling.

 

[Peter_SSs]

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?

 

[docwoody]

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.

 

[Peter_SSs]

Unfortunately my work account will not open any of the other links.

That does make it a bit harder, but see my reply in the Test Forum

 

[Hjemmet]

Take A look at this

https://excel-example.com/templates/sport-tournament-template

what you should search for is called Round Robin why it call that I dont know