Random numbers

J

Jane@Rakiraki

I have a spread sheet with 10, 000 numbers on it. 1 - 10000. I need to
jumble all the numbers up to make them completely random. Has anyone any
ideas how do this on such a scale?

Thanks
 
H

Harlan Grove

Jane@Rakiraki said:
I have a spread sheet with 10, 000 numbers on it. 1 - 10000. I need to
jumble all the numbers up to make them completely random. Has anyone any
ideas how do this on such a scale?
Click to expand...

If these numbers were in A1:A10000 and B1:B10000 were all blank, enter the
formula =RAND() in B1, fill B1 down into B2:B10000, sort A1:B10000 on column
B in either ascending or descending order (it doesn't matter). This will
shuffle A1:A10000. Clear B1:B10000.
 
Top