Random numbers no repeats

Copper Contributor

How do I get random numbers no repeaters zero 109

1 Reply

@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.