| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i generate random numbers between 10000 and 65000
I want to create a list 55000 whole numbers between 10000 and 65000. How can
i do this please? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i generate random numbers between 10000 and 65000
In one column put 10,000 to 65,000. In the next column use the RAND()
function. Sort by the second column to get a random order of your desired numbers. -- Damon Longworth 2006 East Coast Excel User Conference April 19/21st, 2006 Holiday Inn, Boardwalk Atlantic City, New Jersey Early Bird Registration Now Open!! www.ExcelUserConference.com 2006 UK Excel User Conference Summer, 2006 London, England "charlieking4747" wrote in message ... I want to create a list 55000 whole numbers between 10000 and 65000. How can i do this please? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i generate random numbers between 10000 and 65000
Make sure the analysis toolpak has been loaded and then in A1 enter:
=RANDBETWEEN(10000,65000) and copy down -- Gary's Student "charlieking4747" wrote: I want to create a list 55000 whole numbers between 10000 and 65000. How can i do this please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
