Using Excel, I record the results of a Bowls Tourney. Each round a team plays a different opponent on a different rink.
Currently I record the results for each opposing team.
Eg. Team A plays Team B on Rink 1
Result for Team A. Win. Points For 10; Points Against 8
Result for Team B. Loss. Points For 8; Points Against 10
Up to 16 teams can participate in each round.
What I wish for is a formula that will pick up Team As result and reverse it for Team B.
Relevant Columns are;
Team Name
Points For
Points Against
Rink Number
Sample File attached
Bookmarks