Display the Average of the Previous 10 Games Dynamically

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!

Hi Glenn,

Thank you for taking the time to reply to my post.

Unfortunately, the data stats in different rows for each player because of the website I am getting the daily updated stats from (basketball reference) has their HTML tables configured differently based on the player's stats. This will push down the main the starting point of the headers for the main table. I am not sure how to change that as this is a web query.

I have since updated the sheet names to match the player's name for ease.

Thank you again!

Hi Glenn,

Sorry i was out of town and just got a chance to get back to you.

I checked the updated workbook you posted a little closer and it looks like it is not pulling the appropriate date. I ran a test with Grant Williams from the drop-down window, and his stats are all off and not the average of the last 10 games. I am wondering if it is because the column headers on the Last10Avgs sheets do not line up exactly with those for each player? For example it looks like the column for points "PTS" is column T in the Last10Avgs, but is column AB for each player. I have attached the spreadsheet again to see if you have any time to check it out again and see if you can help with this issue.

Thank you again!

Unfortunately, it is not correctly pulling the previous ten games. I checked with Grant Williams again and looked under PTS and TRB by first calculating the average on his individual sheet (they just played last night so I had to make sure to update the data first). The TRB average should be 5.3 and the PTS average should be 6.5 (but it says 4.4 and 9.5, respectively on the last10avg sheet).

I really appreciate you taking the time to look at this problem and I apologize if I have not been as clear you would like, but if you have any time to look at this again I would really appreciate it. I completely understand if you are no longer interested though.

Either way, cheers!

BostonCelticsPlayers (2).xlsx

Hi Menem,

So sorry that I did not reply to you earlier!

This is a very useful sheet and it definitely shows me the last ten game averages (THANK YOU!). Is there a way to add a drop down list of the players that will show me these stats dynamically, instead of listing all of the players? I want to build this out to eventually have all of the players in the league on the drop down so it would be great if I could just look at one player at a time if I wanted to instead of having to scroll through a sheet with all of the players.

Thank you again, I really appreciate you taking the time to put this together!

Thank you Glenn that works!