Random numbers no repeats

Occasional Visitor

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:


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.