Results 1 to 12 of 12

Generate Random Numbers Between 0-9

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Generate Random Numbers Between 0-9

    I am trying to generate random numbers between 0 - 9 in ten cells that do not repeat an always include every value 0 - 9 (0, 1, 2, 3, 4,...9). The object is to have the numbers randomize each time. So cells A1:A10 could look like this:

    3
    9
    4
    5
    1
    0
    6
    8
    7
    2

    Or, they could look like this:

    9
    7
    5
    2
    8
    4
    1
    3
    6
    0

    I understand the rand and randbetween formulas, but am having trouble finding the logic to make them non-repeating, all inclusive and still random.

    Any help? A bonus point for anyone who can figure out what this is for (hint: there is a kick-off in about four hours).
    Last edited by dreicer_Jarr; 02-02-2009 at 08:52 PM. Reason: Now Solved

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