How can i generate random numbers between 10000 and 65000

[charlieking4747]

I want to create a list 55000 whole numbers between 10000 and 65000. How can
i do this please?

[Damon Longworth]

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" <charlieking4747@discussions.microsoft.com> wrote in
message news:12F8EDFD-D461-4385-9BBB-592748BD10CD@microsoft.com...
I want to create a list 55000 whole numbers between 10000 and 65000. How can
i do this please?

[Gary''s Student]

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?