Hello! I was happy to find this forum when I Googled for Excel help and so here I am, a new member.
I am trying to use Excel to generate a game schedule for my fantasy football league. Right now I handle this task manually but I figured there has to be a way for Excel to work it out.
Let's say I have 16 teams playing 16 games. I have a table written out using numbers to represent the different teams. The x-axis has one team number per column while the y-axis has a week number in each row. The intersection of any column with each row shows the x-axis team's opponent for the week. What I want to do is substitute a team name or abbreviation for the team numbers in the body of the table and then generate a formula (or script? - I'm not sure of the correct terminology) to then produce a listing of the games each week. So the output would look something like this:
Week 1
BNS v ROC
NYL v NFB
WBB v TCF
etc...
Each 3 letter abbreviation represents a team name. This would significantly reduce the amount of manual work I have to do since Excel would generate the game schedule as above for each week and then I take that information and dump it into the software I use to run the League.
So nothing serious such as a work project but a task nonetheless that I need to get done. Any input is appreciated!
Thanks!
Bookmarks