Random Numbers

[KII]

Is it possible to generate 6 random numbers between 1 and 49.

Kev@stmerryn.co.uk

 

[staticbob]

You doing the lottery then ??

try looking at the help for the RAND function . .

will be something like RAND()*(b-a)+a
where a is 1 and b is 49

so . . =rand()*(1-49)+a

Bob.

 

[earlyd]

=ROUNDUP(RAND()*49,0) will generate a random number between 1 and 49. If you want the six numbers to be unique you will have to do a little more.

 

[plettieri]

Hi:

Sounds like a much similar (exact) question here

http://www.mrexcel.com/board2/viewtopic.php?t=18559&highlight=random+number+range

plettieri