# RANDBETWEEN, No duplicates, Static

Bob G
Guest
Posts: n/a

 21st May 2004
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
Guest
Posts: n/a

 21st May 2004
Hi
see:
http://www.mvps.org/dmcritchie/excel/random.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Bob G" <(E-Mail Removed)> schrieb im Newsbeitrag
news:102b701c43f33\$ea108650\$(E-Mail Removed)...
> 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
Guest
Posts: n/a

 21st May 2004
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" <(E-Mail Removed)> schrieb im

Newsbeitrag
>news:102b701c43f33\$ea108650\$(E-Mail Removed)...
>> 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
Guest
Posts: n/a

 21st May 2004
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" <(E-Mail Removed)> schrieb im Newsbeitrag
news:103df01c43f3b\$f850ed10\$(E-Mail Removed)...
> 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" <(E-Mail Removed)> schrieb im

> Newsbeitrag
> >news:102b701c43f33\$ea108650\$(E-Mail Removed)...
> >> 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?

> >
> >.
> >

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post rogercnorris@yahoo.com Microsoft Dot NET Framework 1 1st Feb 2005 06:34 PM Ben Microsoft ASP .NET 3 1st Jun 2004 08:43 PM Natan Microsoft ASP .NET 8 26th May 2004 09:21 AM CW Microsoft ASP .NET 1 31st Mar 2004 06:34 PM Tilfried Weissenberger Microsoft Dot NET Framework 2 20th Jul 2003 08:25 PM

Features