Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: RANDOM NUMBERA

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    HOW CAN I CREATE A LIST OF RANDOM NUMBERS WITHOUT ANY OF THEM REPEATING THEMSELVES.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    there's quite a few good examples already on this board.... try a quick search on "=RAND" or "=RANDBETWEEN" you'll probably find exactly what you need...... if not, wait a while and there'll be a few suggestions, I'm sure of it !
    :: Pharma Z - Family drugstore ::

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-23 04:50, abz2max wrote:
    HOW CAN I CREATE A LIST OF RANDOM NUMBERS WITHOUT ANY OF THEM REPEATING THEMSELVES.
    1. Enter =RAND() in cell A1 and fill down as many rows as numbers needed.
    2. Enter =RANK(A1,A:A) into cell B1 and fill down to used last row in column A.

    [ This Message was edited by: Mark W. on 2002-04-23 06:54 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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