I am building a statistics workbook to track each NBA player. As a part of that I have a web query running for each player from Baseketball-Reference. As you will see in the spreadsheet I attached each player has their own sheet and the stats will automatically update with new data in the bottom column.
I have a "master" sheet that has the averages for each of the different statistics for each player and updates accordingly (in the example I attached it is the "BOS Total" sheet).
The next thing I have been trying to build is to have a more dynamic sheet where I can select any player from a drop-down list and if that player is selected it will return the average for ONLY the last 10 games (ignoring games that the player was inactive or did not play).
The sheet "Last10Avgs" has an example of what I am trying to do.
Thank you in advance for reading/your help!
Bookmarks