Forum Discussion
Tennis doubles win percentage table help
My club is in a tennis league and we regularly play matches with different partners. I would like to create a table that automatically combines the data so we can learn which two-player teams have th...
This is a great start, thank you!
I played around with the example and it works well. We have almost 30 guys on our team, which could result in 100 different pairings, which could be difficult to manage in Table 2. Is there a way for Table 2 to create the pairings automatically when I create them in Data/Table 1?
I played around with the example and it works well. We have almost 30 guys on our team, which could result in 100 different pairings, which could be difficult to manage in Table 2. Is there a way for Table 2 to create the pairings automatically when I create them in Data/Table 1?
fensterbos I am attaching a new copy with a formula to automatically calc all combinations. I modified a code recently done for another recent post (challenge). In this example I used OliverScheurich 's approach as I think it may be cleaner but either works
EDIT: modified attached to use array formulas for the total matches and Win %