Forum Discussion
Solved
Random Number Generator without duplicates
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 bo...
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.
A quick way to generate Randon unique number is using the new array formulas such as :
=SORT(UNIQUE(RANDBETWEEN(SEQUENCE(50,1,1,1),70)))
You can make some arrangements to exclude or include numbers with that approach.
=SORT(UNIQUE(RANDBETWEEN(SEQUENCE(50,1,1,1),70)))
You can make some arrangements to exclude or include numbers with that approach.
Hi Juliano,
Thanks for your prompt reply. I'll have to give this a test.
Would I have to amend the formula each time to exclude the numbers generated though?
Thanks for your prompt reply. I'll have to give this a test.
Would I have to amend the formula each time to exclude the numbers generated though?