+ Reply to Thread
Results 1 to 3 of 3

How can i generate random numbers between 10000 and 65000

  1. #1
    charlieking4747
    Guest

    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. #2
    Damon Longworth
    Guest

    Re: 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" <[email protected]> wrote in
    message news:[email protected]...
    I want to create a list 55000 whole numbers between 10000 and 65000. How can
    i do this please?



  3. #3
    Gary''s Student
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1