Power Query - Darts Recent Results

Post Reply
User avatar
paspuggie48
Posts: 619
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Power Query - Darts Recent Results

Darts - Recent Results.xlsx

This PQ allows one to select two Players (A & B) from their retrospective drop-down menu, which will let you compare recent results.

(data validation is on a separate sheet)

The players available are from the Top 100 according to the PDC website but you can add more to the DV sheet if you wish. However the recent results are pulled from the Mastercaller website (so if it is missing a player I cannot guarantee the data will pull through).

Select your Players from the drop-downs, then select Data > Refresh All.

I did have a macro version with a clickable refresh button but I cannot upload xlsm. Unless it's just me?
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2147
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

180!! just in time for the world championships starting tomorrow
Post Reply

Return to “Excel Power Query”