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 Nevertheless, I created a list for 8 teams, Home and Away. Copied the "table" from the website and dumped it into Excel. As you mentioned, it's not very useful. But, with some Power Query (PQ) steps, I could fairly easily create a table that has fixture number (1 through 14) and Home and Away team for the four matched in every fixture. I didn't attempt to optimise or even clean-up the query, but just wanted to demonstrate that PQ can transform seemingly useless data sets to something very useful.
Would this be a starting point for your match schedule?
Thankyou for that but its not really what i am after plus I dont know whar Power Query is.
I have a League table linked to the fixtures list sheet with score columns directly linked to table -the Fixtures list is really basic with four columns including Home Team, Home Score , Away Score , Away team.
Thanks Again
Rick
rick8651 Fair enough, but don't really understand what you mean by "I have a League table linked to the fixtures list sheet". So you already have a fixtures list? Why then ask for something that can generate a list? Why not upload what you already have and explain what you want to do with it?
- because everyone else understands what he is asking for?
- The list I use at the moment I have to type in by hand with 480 fixtures a season this takes a fair bit of time hence why I am looking to do it automatically - the league table I found on internet with calculations already done but no fixtures generator.
Thanks for your help its much appreciated.
Regards
Rickrick8651 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.
