# RANDBETWEEN, No duplicates, Static

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

1. ### Bob GGuest

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

2. ### Frank KabelGuest

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

3. ### Bob GGuest

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
4. ### Frank KabelGuest

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