Random numbers
 

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

Random numbers
 

Take a look at the worksheet method he

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

In article ,
Jane@Rakiraki wrote:

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

Random numbers
 

"Jane@Rakiraki" wrote...
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.