How can i generate random numbers between 10000 and 65000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct and Wildcards 4
mathing values 3
Access How can i delete record from 7000 to 65000 in MS Access Table? 0
Random numbers 5
Sumproduct and if statements 4
sumproduct by quarter 4
Sumif Criteria 6
How can I limit Access query to 65000 records 4

Back
Top