I want to create a list 55000 whole numbers between 10000 and 65000. How can
i do this please?
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
quot;charlieking4747quot; gt; wrote in
message ...
I want to create a list 55000 whole numbers between 10000 and 65000. How can
i do this please?
Make sure the analysis toolpak has been loaded and then in A1 enter:
=RANDBETWEEN(10000,65000)
and copy down
--
Gary's Studentquot;charlieking4747quot; wrote:
gt; I want to create a list 55000 whole numbers between 10000 and 65000. How can
gt; i do this please?
- Sep 29 Fri 2006 20:09
How can i generate random numbers between 10000 and 65000
close
全站熱搜
留言列表
發表留言