multifidus
New Member
- Joined
- Feb 2, 2023
- Messages
- 14
- Office Version
- 365
- Platform
- MacOS
I am building a database that has all of the statistics for each NBA player this season. Each team has their own workbook (example: LosAngelesLakersPlayers.xslx) and each player has their own sheet (example: James_LeBron), with each game in a single row, with each new game being added at the bottom row. I have a formula that is showing the average values for all the main categories for every player on a single spreadsheet.
I want to add separate columns that shows a player's 5 most recent results for a given statistic. In other words, I would like it to pull from the player's spreadsheet and display how many assists they got in the each of the last five games (not an average of the last five), separated by commas. I am not sure what function would be the best way to start as the spreadsheets update whenever the player had a new game.
Any advice/suggestions would be greatly appreciated.
Thank you!
I want to add separate columns that shows a player's 5 most recent results for a given statistic. In other words, I would like it to pull from the player's spreadsheet and display how many assists they got in the each of the last five games (not an average of the last five), separated by commas. I am not sure what function would be the best way to start as the spreadsheets update whenever the player had a new game.
Any advice/suggestions would be greatly appreciated.
Thank you!