Welcome Guest
( Log In | Register )
The time is now 6:34 am
You last visited January 23, 2017, 5:30 am
All times shown are
Eastern Time (GMT-5:00)

Creating Random Generator in EXCEL

Published:

For 3 separate column (A1,B1,C1), Type/copy normula in each:

=MOD((INT(RAND()*10)+1),10)

For 1 column, type:

=INT(RAND()*999)

For other games, MegaMillion, etc:

=INT(RAND()*52)+1   

Where the "52" is, for any game, just insert the number of balls used in the drawing, and copy normula to 4,5 or 6 columns.     

To change (generate) the pickings, 

Click  F9     

Everytime you use and X out, it will ask if you want to save.  No need to do this, except the FIRST time.

Good luck!

 

 

 

Entry #12

Comments

This Blog entry currently has no comments.

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.