Forum Discussion
Random Number Generator without duplicates
ChrisBentham No, I started off with a list of "names" Player1 to Player50. Then I added the formula =RAND() in C2 and then copied it down. Now you have several options. You can keep the column with the RAND() formula and sort it. That will result in some kind of random sort that you can redo if you don't like it. Or you copy-paste values these random numbers and then sort them in ascending or descending order. It will, either way, instantly create a list that you can pick your pairings from. I chose the latter option.
ChrisBentham Don't know what online booking system you have, but it should not be a problem to import a list from it. Then just add a random number in the next column and sort that random number in any order. Now, just pick your groups of 2, 3 or 4 players starting from the top.
Example attached.
Apologises if I'm being a bit simple. I'm far from an expert on Excel.
In the player column it has the player number in random orders. Have you just manually inputted that yourself? And how does the rand() function in the 2nd column help in this instance.
Kind regards,
Chris
ChrisBentham No, I started off with a list of "names" Player1 to Player50. Then I added the formula =RAND() in C2 and then copied it down. Now you have several options. You can keep the column with the RAND() formula and sort it. That will result in some kind of random sort that you can redo if you don't like it. Or you copy-paste values these random numbers and then sort them in ascending or descending order. It will, either way, instantly create a list that you can pick your pairings from. I chose the latter option.