no number 1

R

redchequer

I came across a program for generating Lottery numbers and tried
adapting it for the game we play which has 15 games with 6 of 45
numbers per sheet, but unfortunately I can''t find it again in the
Excel forum
The formula entered at *A1* and dragged across & down to *F15* was:
=INDEX(ROW($B2:$B41),RANK(I2,$I2:$AL2))
At *H1* the formula entered and dragged across & down to *AK15* was
*=RAND()*, I found that by putting more than 30 columns it generated
numbers higher than 45
This program will generate random numbers 2 to 45 but I can't get it to
bring up a 1..
re calculates by pressing F9

How can I get it to generate the number 1.
 
K

kk

Hi,

redchequer said:
I came across a program for generating Lottery numbers and tried
adapting it for the game we play which has 15 games with 6 of 45
numbers per sheet, but unfortunately I can''t find it again in the
Excel forum
Click to expand...

I think you're seaching for this http://tinyurl.com/a5y9d
I adapted the concept as well with small change.
The formula entered at *A1* and dragged across & down to *F15* was:
=INDEX(ROW($B2:$B41),RANK(I2,$I2:$AL2))
Click to expand...

In my starting cell A1, I make a small changes to the formula...

=Index(Row($1:$45),Rank(H1,$H1:$AZ1)

and dragged across & down to F15
At *H1* the formula entered and dragged across & down to *AK15* was
*=RAND()*, I found that by putting more than 30 columns it generated
numbers higher than 45
Click to expand...

Using the same formula =RAND(), I start at H1 and dragged across & down to
AZ15

And I alway getting the number starting from 1 to 45 by recalculates the
worksheet using F9.

kk
 
Top