RANDBETWEEN, No duplicates, Static

Discussion in 'Microsoft Excel Worksheet Functions' started by Bob G, May 21, 2004.

  1. Bob G

    Bob G Guest

    Goals: 1. To create a six column table (for lottery
    numbers, 1-54) with each "row" containing a unique number
    (no duplicate numbers in the row). 2. To keep the
    table "cells" static (i.e., no automatic recalculation of
    the random numbers) after it is created (unless I
    intentionally want to generate a new set of numbers).

    Results so far: For each "cell" the formula =RANDBETWEEN
    (BOTTOM,TOP) works as expected but goals 1 and 2 have not
    been achieved.

    Possible solutions?
     
    Bob G, May 21, 2004
    #1
    1. Advertisements

  2. Bob G

    Frank Kabel Guest

    Hi
    see:
    http://www.mvps.org/dmcritchie/excel/random.htm

    --
    Regards
    Frank Kabel
    Frankfurt, Germany

    "Bob G" <> schrieb im Newsbeitrag
    news:102b701c43f33$ea108650$...
    > Goals: 1. To create a six column table (for lottery
    > numbers, 1-54) with each "row" containing a unique number
    > (no duplicate numbers in the row). 2. To keep the
    > table "cells" static (i.e., no automatic recalculation of
    > the random numbers) after it is created (unless I
    > intentionally want to generate a new set of numbers).
    >
    > Results so far: For each "cell" the formula =RANDBETWEEN
    > (BOTTOM,TOP) works as expected but goals 1 and 2 have not
    > been achieved.
    >
    > Possible solutions?
     
    Frank Kabel, May 21, 2004
    #2
    1. Advertisements

  3. Bob G

    Bob G Guest

    Thanks, I viewed the MVP site as suggested but how do we
    convert the random numbers to constants as mentioned in
    the solution?
    >-----Original Message-----
    >Hi
    >see:
    >http://www.mvps.org/dmcritchie/excel/random.htm
    >
    >--
    >Regards
    >Frank Kabel
    >Frankfurt, Germany
    >
    >"Bob G" <> schrieb im

    Newsbeitrag
    >news:102b701c43f33$ea108650$...
    >> Goals: 1. To create a six column table (for lottery
    >> numbers, 1-54) with each "row" containing a unique

    number
    >> (no duplicate numbers in the row). 2. To keep the
    >> table "cells" static (i.e., no automatic recalculation

    of
    >> the random numbers) after it is created (unless I
    >> intentionally want to generate a new set of numbers).
    >>
    >> Results so far: For each "cell" the formula =RANDBETWEEN
    >> (BOTTOM,TOP) works as expected but goals 1 and 2 have

    not
    >> been achieved.
    >>
    >> Possible solutions?

    >
    >.
    >
     
    Bob G, May 21, 2004
    #3
  4. Bob G

    Frank Kabel Guest

    Hi
    but this is outlines in this page. It stores the unique random numbers
    in an array and puts them on a sheet?

    --
    Regards
    Frank Kabel
    Frankfurt, Germany

    "Bob G" <> schrieb im Newsbeitrag
    news:103df01c43f3b$f850ed10$...
    > Thanks, I viewed the MVP site as suggested but how do we
    > convert the random numbers to constants as mentioned in
    > the solution?
    > >-----Original Message-----
    > >Hi
    > >see:
    > >http://www.mvps.org/dmcritchie/excel/random.htm
    > >
    > >--
    > >Regards
    > >Frank Kabel
    > >Frankfurt, Germany
    > >
    > >"Bob G" <> schrieb im

    > Newsbeitrag
    > >news:102b701c43f33$ea108650$...
    > >> Goals: 1. To create a six column table (for lottery
    > >> numbers, 1-54) with each "row" containing a unique

    > number
    > >> (no duplicate numbers in the row). 2. To keep the
    > >> table "cells" static (i.e., no automatic recalculation

    > of
    > >> the random numbers) after it is created (unless I
    > >> intentionally want to generate a new set of numbers).
    > >>
    > >> Results so far: For each "cell" the formula =RANDBETWEEN
    > >> (BOTTOM,TOP) works as expected but goals 1 and 2 have

    > not
    > >> been achieved.
    > >>
    > >> Possible solutions?

    > >
    > >.
    > >
     
    Frank Kabel, May 21, 2004
    #4
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Andreas

    Randbetween without duplicates?

    Andreas, Jul 17, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    2,028
    Tom Ogilvy
    Jul 17, 2003
  2. Rita Nikas [MSFT]

    Excel 2003: RAND and RANDBETWEEN functions

    Rita Nikas [MSFT], Dec 20, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    22
    Views:
    1,118
    Norman Harker
    Feb 14, 2004
  3. OldDj

    RandBetween Question

    OldDj, Jan 5, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    6
    Views:
    487
    Norman Harker
    Jan 6, 2004
  4. David Byrne

    RAND and RANDBETWEEN Workaround........An A Comment

    David Byrne, Jan 15, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    7
    Views:
    1,093
    Harlan Grove
    Jan 18, 2004
  5. RAND

    Stop automatically changing value in =RAND or =RANDBETWEEN

    RAND, Jan 23, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    9
    Views:
    74,182
    shirisha
    Feb 18, 2016
  6. OldDj

    RandBetween without duplicating

    OldDj, Jan 27, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    6
    Views:
    1,949
    Ken Wright
    Jan 27, 2004
  7. Dominique Feteau

    Randbetween Function

    Dominique Feteau, Mar 23, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    511
    Dana DeLouis
    Mar 23, 2004
  8. Guest

    How do you avoid duplicates when using the randbetween function?

    Guest, Feb 15, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    2,825
    JE McGimpsey
    Feb 16, 2006
Loading...