Velocity Reviews > Random Numbers In Excel

# Random Numbers In Excel

BIGEYE
Guest
Posts: n/a

 03-12-2006
I have put together a spreadsheet with six cells, each cell generating a
random number between 1 and 49. It is for selecting lottery numbers,
probably have more luck with this than picking my own numbers.
Anyway, how can I set up each cell to check for repeat numbers and not
generate repeat numbers.
TIA.

old man
Guest
Posts: n/a

 03-12-2006
Why not use either the lottery site random generator, or the one accessed
via BBC site
http://www.bbc.co.uk/lottery/
But then perhaps you wish to 'play' with excel, or dont trust these?

"BIGEYE" <(E-Mail Removed)> wrote in message
news:44144b9f\$0\$5000\$(E-Mail Removed)...
> I have put together a spreadsheet with six cells, each cell generating a
> random number between 1 and 49. It is for selecting lottery numbers,
> probably have more luck with this than picking my own numbers.
> Anyway, how can I set up each cell to check for repeat numbers and not
> generate repeat numbers.
> TIA.
>
>

BIGEYE
Guest
Posts: n/a

 03-12-2006
Playing around with Excel. Used to use Lotus 123, but switched due to work
requirements.

"old man" <(E-Mail Removed)> wrote in message
news:7JYQf.932\$(E-Mail Removed)...
> Why not use either the lottery site random generator, or the one accessed
> via BBC site
> http://www.bbc.co.uk/lottery/
> But then perhaps you wish to 'play' with excel, or dont trust these?
>
> "BIGEYE" <(E-Mail Removed)> wrote in message
> news:44144b9f\$0\$5000\$(E-Mail Removed)...
>> I have put together a spreadsheet with six cells, each cell generating a
>> random number between 1 and 49. It is for selecting lottery numbers,
>> probably have more luck with this than picking my own numbers.
>> Anyway, how can I set up each cell to check for repeat numbers and not
>> generate repeat numbers.
>> TIA.
>>
>>

>
>

old man
Guest
Posts: n/a

 03-12-2006
BTW I hope that isnt your real email add - if so 'munge' it or be prepared
to be harvested

"BIGEYE" <(E-Mail Removed)> wrote in message
news:44145808\$0\$29574\$(E-Mail Removed)...
> Playing around with Excel. Used to use Lotus 123, but switched due to work
> requirements.
>
> "old man" <(E-Mail Removed)> wrote in message
> news:7JYQf.932\$(E-Mail Removed)...
> > Why not use either the lottery site random generator, or the one

accessed
> > via BBC site
> > http://www.bbc.co.uk/lottery/
> > But then perhaps you wish to 'play' with excel, or dont trust these?
> >
> > "BIGEYE" <(E-Mail Removed)> wrote in message
> > news:44144b9f\$0\$5000\$(E-Mail Removed)...
> >> I have put together a spreadsheet with six cells, each cell generating

a
> >> random number between 1 and 49. It is for selecting lottery numbers,
> >> probably have more luck with this than picking my own numbers.
> >> Anyway, how can I set up each cell to check for repeat numbers and not
> >> generate repeat numbers.
> >> TIA.
> >>
> >>

> >
> >

>
>

Guest
Posts: n/a

 03-12-2006
BIGEYE wrote:

> Playing around with Excel. Used to use Lotus 123, but switched due to work
> requirements.

Good reason. Exploration is good. I used to do Quattro Pro along
side Lotus, then went through an Excel phase and now use Open Office.
That said, I have a lottery question. The state lottery where I live in
the US (and probably the others here, as well) has a "Quick Pick" option
where instead of selecting your own numbers you have the terminal randomly
generate them for your ticket. Is such a pick available on the lottery
you're playing?

--
Killing all posts from Google Groups
Coming Soon: Filter rules specific to various real news clients

Guest
Posts: n/a

 03-12-2006
see:

http://tinyurl.com/ocpud

=?ISO-8859-1?Q?Brian_H=B9=A9?=
Guest
Posts: n/a

 03-12-2006
> BIGEYE wrote:
>
>
>>Playing around with Excel. Used to use Lotus 123, but switched due to work
>>requirements.

>
>
> Good reason. Exploration is good. I used to do Quattro Pro along
> side Lotus, then went through an Excel phase and now use Open Office.
> That said, I have a lottery question. The state lottery where I live in
> the US (and probably the others here, as well) has a "Quick Pick" option
> where instead of selecting your own numbers you have the terminal randomly
> generate them for your ticket. Is such a pick available on the lottery
> you're playing?
>
>

Yes, we call it a lucky dip.

fkasner
Guest
Posts: n/a

 03-12-2006
BIGEYE wrote:
> I have put together a spreadsheet with six cells, each cell generating a
> random number between 1 and 49. It is for selecting lottery numbers,
> probably have more luck with this than picking my own numbers.
> Anyway, how can I set up each cell to check for repeat numbers and not
> generate repeat numbers.
> TIA.
>
>

After generating a random (not really a very good random generator) in
cell one generate another in cell 2. Compare cell 2 to cell 1. If
difference between values is not zero go to cell three and generate
another random number. If difference between 1 and 2 is zero generate a
new random number for cell 2. Save difference in cell 7. etc., etc.

Or you can just compare each new random to all the randoms that preceded
it and if any one of them is zero then regenerate the random number and
do the test again. Go to next cell and generate another random number
and repeat the test previously reported.

The simple arithmetic of these integer calculations should allow a very
rapid operation of a this slightly complicated method.

There are clearly some more complicated methods possible but aren't
worth the trouble of all that thought to arrive at them.

FK

slumpy
Guest
Posts: n/a

 03-12-2006
To fill up a few lines of text and ultimately to **** off a lot of dumb
people, I typed this just before Brian H¹© decided to brighten up my day by
saying:

> > BIGEYE wrote:
> >
> >
> > > Playing around with Excel. Used to use Lotus 123, but switched
> > > due to work requirements.

> >
> >
> > Good reason. Exploration is good. I used to do Quattro Pro along
> > side Lotus, then went through an Excel phase and now use Open
> > Office. That said, I have a lottery question. The state lottery
> > where I live in the US (and probably the others here, as well) has
> > a "Quick Pick" option where instead of selecting your own numbers
> > you have the terminal randomly generate them for your ticket. Is
> > such a pick available on the lottery you're playing?
> >
> >

>
> Yes, we call it a lucky dip.

And look at what you pulled out !

Woohoo !!
--
slumpy
The SS Wereo - http://tinyurl.com/beg2o
The Ballad of Scott Lifshine 2006 - http://tinyurl.com/8y5vw - warning -
this is a NIL BY MOUTH WEBPAGE - the author is not responsible for any
computer damage caused by spat or spilt foods