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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Andreas

    Randbetween without duplicates?

    Andreas, Jul 17, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    1,152
    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:
    798
    Norman Harker
    Feb 14, 2004
  3. OldDj

    RandBetween Question

    OldDj, Jan 5, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    6
    Views:
    265
    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:
    742
    Harlan Grove
    Jan 18, 2004
  5. Guest

    How do you avoid duplicates when using the randbetween function?

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

Share This Page