mcpwayne2005
New Member
- Joined
- Jul 3, 2008
- Messages
- 6
Hello,
I'm creating a work book that will track games played for an 8 person league. I have listed in each week each game played and the score of those games. I'd like to do a couple things:
1.) Create a standings table to show each team's win-loss record and points for an against.
2.) Create a table that shows a person's win-loss record for individual opponents. I have included some screen shots below as a guide.
<tbody>
</tbody>
<tbody>
</tbody>
I would like the "standings table" and the "record vs other teams" table to automatically populate. Any help you can offer would be greatly appreciated
I'm creating a work book that will track games played for an 8 person league. I have listed in each week each game played and the score of those games. I'd like to do a couple things:
1.) Create a standings table to show each team's win-loss record and points for an against.
2.) Create a table that shows a person's win-loss record for individual opponents. I have included some screen shots below as a guide.
| WEEK | GAME | ||||
| WEEK 1 | ADAM | 101.28 | VS | 135.86 | FRANK |
| CRAIG | 78.60 | VS | 105.80 | BEN | |
| JIMMY | 99.58 | VS | 102.28 | MATT | |
| CHUBBS | 132.08 | VS | 134.96 | LAMARR | |
| WEEK 2 | ADAM | 65.68 | VS | 155.92 | CHUBBS |
| CRAIG | 115.52 | VS | 138.32 | JIMMY | |
| BEN | 171.80 | VS | 110.60 | LAMARR | |
| FRANK | 118.50 | VS | 119.00 | MATT |
<tbody>
</tbody>
| RECORD VS OTHER TEAMS | ||||||||||||||||
| ADAM | FRANK | CHUBBS | LAMARR | BEN | JIMMY | MATT | CRAIG | |||||||||
| W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | |
| ADAM | ||||||||||||||||
| FRANK | ||||||||||||||||
| CHUBBS | ||||||||||||||||
| LAMARR | ||||||||||||||||
| BEN | ||||||||||||||||
| JIMMY | ||||||||||||||||
| MATT | ||||||||||||||||
| CRAIG |
<tbody>
</tbody>
I would like the "standings table" and the "record vs other teams" table to automatically populate. Any help you can offer would be greatly appreciated
