bowlerden300
New Member
- Joined
- Dec 25, 2016
- Messages
- 12
Hi i am relatively new to excel so hope that i am not making a huge mess of this.
i have created a table of 20 rows and 19 columns the rows are of bowlers names and a number suffix ie: rob1 and the columns are headed with weeks 1 -19. I wish to fill the table with fixtures where each player plays each other once. so i wondered if i could use some sort of formula to add the player numbers to the table randomly so they appear only once on each row and column remembering a player cant play himself so player 1 row would not feature a number 1 etc. I have tried to do it manually but it takes so long and i always end up with a number duplicated at some point so an automatic way would be a great benefit any help will be gratefully accepted.
Thank you
Den
i have created a table of 20 rows and 19 columns the rows are of bowlers names and a number suffix ie: rob1 and the columns are headed with weeks 1 -19. I wish to fill the table with fixtures where each player plays each other once. so i wondered if i could use some sort of formula to add the player numbers to the table randomly so they appear only once on each row and column remembering a player cant play himself so player 1 row would not feature a number 1 etc. I have tried to do it manually but it takes so long and i always end up with a number duplicated at some point so an automatic way would be a great benefit any help will be gratefully accepted.
Thank you
Den