Dec 17 2021 03:50 AM
Hi Everyone,
So I'm trying to use Microsoft Excel in order to do a random draw for a golf competition. Random draws are as simple as they sound. Players will enter their names onto our online booking system. We then take the names off, number them 1-50 (Or however many entries there are) for example then generate 1 number at a time, crossing off the name drawn out then keep on drawing names out till everyone has been drawn. This way playing partners will be completely random. Aside from the fact that it's a slightly time consuming process a random number generator will sometimes bring up the same number twice.
I'd like to use Excel to import the names from our online booking system (Saves writing them down each time) and then use a formula to randomly pick out individuals but each time removing that player. This way after the first draw the random generator will only be selecting from 49 names instead of 50. Then I could simply drag the formula into the desidered cells and complete the entire draw in seconds.
Any help would be much appreciated. I'm available to answer any further questions as well
Kind regards,
Chris
Dec 17 2021 04:06 AM
Dec 17 2021 04:08 AM
Dec 17 2021 04:10 AM
@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.
Dec 17 2021 04:15 AM
Dec 17 2021 04:48 AM
Solution@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.
May 07 2022 06:02 AM
Dec 17 2021 04:48 AM
Solution@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.