Welcome Guest
( Log In | Register )
The time is now 1:24 pm
You last visited January 18, 2017, 1:04 pm
All times shown are
Eastern Time (GMT-5:00)

Excel formula for Random picker

Published:

Last Edited: June 30, 2005, 10:25 am

To produce 1 set of three numbers, type formula in Column (A):

=INT(RAND()*999)

Using 3 columns to produce 1# in each, type this formula, then copy to (B) (C):

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

To change/generate a different answer, Click F9. You can hold F9 down or just touch it once. It will ask each time you open it, if you want to save…only need to save the FIRST time.

 

 

For other lottery games, you can use this formula…just change the “53” to match the number of balls used in the game you are working with:

=INT(RAND()*53)+1

If it is 5 balls, plus a bonus: insert formula into 5 columns and in 6th-change number to match balls for the Bonus drawing, if different from the first ones.

Entry #18

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.