Random generator 1-36

[louis128]

hi to all ,i would like a random genarator which gives numbers from 1-38 ,i want only 47 results at a time B1:B47,thanks so much!

[Olly]

So in B1:B47, enter the formula:

Please Login or Register  to view this content.

(your title suggests 1-36, your post suggests 1-38...)

[louis128]

yes 36 , imake mistake, sorry

[louis128]

and how can i change the next results olly?

[louis128]

do i have to drag down again and again?

[Olly]

That formula will generate new random numbers on every recalculation - so click Formulas > Calculate Now, or press F9, to generate a new set of random numbers.

[louis128]

thanks so much!