Forum Discussion
excel formula help
Hi everyone, First I just want to thank all of you for your extraordinary abilities! Here is my problem. I want to track basketball teams, players and the points scored per game. The first sheet ...
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
I've created an 8th team for you. All you would need to do is type in the coach's name and the roster names on the first tab (Teams List) and everything else will populate.
Also, I made it so that each team has a 10 player roster potential. There are a lot of "N/A"s on the game tabs right now but those go away once you select a coach from the drop-down menu in the blue and orange sections.
Hope you like it! Thanks!