Forum Discussion

jaymac98's avatar
jaymac98
Copper Contributor
Mar 28, 2022

Random numbers no repeats

How do I get random numbers no repeaters zero 109

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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.

Resources