- Random Numbers In Excel
- Posted by BIGEYE on March 12th, 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.
- Posted by old man on March 12th, 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" <karen.enderby@ntlworld.com> wrote in message
news:44144b9f$0$5000$db0fefd9@news.zen.co.uk...
- Posted by BIGEYE on March 12th, 2006
Playing around with Excel. Used to use Lotus 123, but switched due to work
requirements.
"old man" <dl@spoofmail.notme> wrote in message
news:7JYQf.932$Tv.18@newsfe5-gui.ntli.net...
- Posted by old man on March 12th, 2006
BTW I hope that isnt your real email add - if so 'munge' it or be prepared
to be harvested
"BIGEYE" <karen.enderby@ntlworld.com> wrote in message
news:44145808$0$29574$da0feed9@news.zen.co.uk...
- Posted by Blinky the Shark on March 12th, 2006
BIGEYE wrote:
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?
--
Blinky
Killing all posts from Google Groups
The Usenet Improvement Project: http://blinkynet.net/comp/uip5.html
Coming Soon: Filter rules specific to various real news clients
- Posted by the paddle on March 12th, 2006
see:
http://tinyurl.com/ocpud
paddle
- Posted by Brian H¹© on March 12th, 2006
Blinky the Shark wrote:
Yes, we call it a lucky dip.
- Posted by fkasner on March 12th, 2006
BIGEYE wrote:
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
- Posted by slumpy on March 12th, 2006
To fill up a few lines of text and ultimately to piss off a lot of dumb
people, I typed this just before Brian H¹© decided to brighten up my day by
saying:
And look at what you pulled out !
Woohoo !!
--
slumpy
tradelist and images - http://tinyurl.com/devgk
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
