-----Original Message-----
Here a problem regarding basketball lineups and team points. The worksheet
looks like this:
P1 P2 P3 P4 P5 PtsF PtsA
PlayerA PlayerB PlayerC PlayerD PlayerE 16 13
PlayerG PlayerB PlayerC PlayerI PlayerE 7 9
PlayerG PlayerF PlayerH PlayerI PlayerE 10 16
PlayerA PlayerF PlayerH PlayerD PlayerJ 9 2
The rows containing "Player" designations (A, B, C, etc.) are the five
players who are in the game at the same time.
Columns P1 through P5 show which player is playing which position (positions
1 - 5)
PtsF is the points the team scores while that 5-player combo is on the court.
PtsA is the points the team allows while that 5-player combo is on the court.
I want to be able to calculate for thousands of rows of data the:
number of points scored and allowed by each five-player combination
number of points scored and allowed when a particular player is on the court
number of points scored and allowed when a particular player is at
different positions
number of points scored and allowed when groups of 2, 3, or 4 players are
on the court
Thanks,
Bob
.
