Forum Discussion
jaymac98
Mar 28, 2022Copper Contributor
Random numbers no repeats
How do I get random numbers no repeaters zero 109
Riny_van_Eekelen
Mar 28, 2022Platinum Contributor
jaymac98 If you are on a recent Excel version you could create such a list in one go by:
=SORTBY(SEQUENCE(110,,0),RANDARRAY(110))
Otherwise, enter the numbers 0 to 109 in one column, let's say from A1 to A110 Then in B1 enter =RAND() and copy it all the way dow to B110.
Now sort column B in any order and you will end upp with a randomly sorted list of numbers in column A.