Forum Discussion
Football Fixture list generator
rick8651 No apologies needed! See attached. I created a fixture list from the website I mentioned earlier and dumped it into column L on the Fixtures sheet, just for your reference. Then I used Power Query to re-shape the list to something more useful. Now, I didn't include the PQ part, but the end result is copied into columns O to Q. Then I added a column to the Dummy Table and assigned a number to each team so that you can use a lookup formula to pick-up the team names based on the numbers in the fixtures table (Home and Away) in columns P and Q.
The best way to learn Excel is to look at the formulae I used, read about how they work and practice, practice.
Attaching your own file with some extras. I hope you'll find it helpful. Good luck!
rick8651 Forgive me for being blunt. You write "the list I have at the moment ......." and "the league table I found on internet with calculations already done but no fixtures generator". If you really want help, you need to give away a bit more. What list? What league table? From which internet site? What do you have currently, and what's missing? Upload your file and explain what's needed. Football matches aren't really confidential, so you have nothing to hide. Otherwise, you are on your own.
Hi,
Thanks for your "Blunt" message, I have attached a copy of my Premier League XL workbook with teams in Dummy Table ready for fixtures for next season which starts in August so hope this is helpful.
ICan I I remind you in my original message I asked if any reply could bear in mind I only know basics of XL and I am not trying to hide anything, I have no idea what is needed to get help with creating a fixture generator.
I originally made the presumption that this was just a case of a few bits of XL code needed to achieve a result but obviously this was a naïve so apologies for that.
Regards
Rick
- Hi,
Many Thanks this looks very useable and I will do some research on formulae to understand it.
I really appreciate your help and time you have spent on doing this for me.
Kindest Regards
Rick rick8651 No apologies needed! See attached. I created a fixture list from the website I mentioned earlier and dumped it into column L on the Fixtures sheet, just for your reference. Then I used Power Query to re-shape the list to something more useful. Now, I didn't include the PQ part, but the end result is copied into columns O to Q. Then I added a column to the Dummy Table and assigned a number to each team so that you can use a lookup formula to pick-up the team names based on the numbers in the fixtures table (Home and Away) in columns P and Q.
The best way to learn Excel is to look at the formulae I used, read about how they work and practice, practice.
Attaching your own file with some extras. I hope you'll find it helpful. Good luck!
