Forum Discussion
excel formula help
Hello there!
-Automatic updating on the Totals tab
-10 game tabs
-Just select from the dropdown arrow for each coach for the game tabs and the team roster will populate
-winning coach automatically updating on each game
Please take a look at the attached spreadsheet. Hopefully it is to your liking. Let me know if you have any questions! Thanks!
Chris,
That is unbelievable! I just have an update to it as I added a player to a team, so there are 9 players on one team. Is there a simple way to add players as I did a copy/paste hoping that it would be able to recognize the formula, but that didn't happen. Please see game1 tab and the added player. Also, when the averages are calculated, are they calculated based on the per game, so if I play 2 games, the formula knows to divide by 2, etc? Or is it based on 10 games. Thanks again for the help!
Dean
Dean,
I am happy you like it so far! I am working on the update to the players now. I'll make is so that there is a possible of 10 per team, that way you have more wiggle room just in case you need it.
Also, to answer the second question, the average points per game will only take the average of the games played so far. So if you have only played 4 games it will automatically average just the first 4 games.
I'll send over the updated file as soon as I am done with it! Thanks!
That's great! Not to make this even more complicated, but if there were 8 teams, how would the formula translate? Would you need to create another grouping and change all the formulas? You got me thinking once you mentioned 10 players per team.
Dean
