ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I create a football team syndicate? (https://www.excelbanter.com/excel-worksheet-functions/115985-how-do-i-create-football-team-syndicate.html)

Needing Help!!

how do I create a football team syndicate?
 
I want to create a team syndicate for 8 teams and set it up so that I just
key in the team names and it works out itself who plays who in the next round
and whether they play home or away. Is it possible?

Bernie Deitrick

how do I create a football team syndicate?
 
No. An easy way to do this is to get the schedule from an eight team league (like Australian A
league) and copy their schedule, then do find and replace...

http://www.a-league.com.au/default.a...=18&roundid=-2

Of course, they play 21 rounds - you could copy just the first seven, or the first fourteen....

HTH,
Bernie
MS Excel MVP


"Needing Help!!" <Needing wrote in message
...
I want to create a team syndicate for 8 teams and set it up so that I just
key in the team names and it works out itself who plays who in the next round
and whether they play home or away. Is it possible?





All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com