| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
| How to select top six numbers from a of range of random numbers | Excel Worksheet Functions | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
Hybrid Mode
