This Power Query gets all the historical T20 Team results (not Internationals). It gets all the data from 2010-2023, some 10,000+ records.
It works by using the URL as the source data link (in the worksheet called "URL"). This is converted to a Function which then scrapes that webpage data and combines it all to create one list.
The URL column is hidden but I've added another columned called "LINK" where the Hyperlink formula is added to create a direct hyperlink, should you want to go to that webpage for that year.
To update the data; right-click with your mouse anywhere on the green Table and select "Refresh". It takes about 30 seconds to refresh.
* In time I may create some more detailed queries that get a lot more match details or in particular Internationals only.
Power Query - T20 Historical Results
- paspuggie48
- Posts: 665
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 665
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Oops, my apologies Dallas. As I've updated this one, deleting the older one is the right call
Cheers buddie