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!
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
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!
- 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
