Random numbers

[Guest]

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

 

[JE McGimpsey]

Take a look at the worksheet method here:

http://www.mcgimpsey.com/excel/udfs/randint.html

 

[Harlan Grove]

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?

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.