Home |
Search |
Today's Posts |
#14
|
|||
|
|||
Think you might also be interested in this program (full details inside):
http://www.savefile.com/files/7565212 File: Randomization_Lotto_program.xls It fits the bill here .. The core functionality is driven via the "RandLotto" UDF by Dave Hawley & JE McGimpsey Just enter the settings for the game in B6 to D6 in the sheet: Draw, for example in your case: From: 1 (in B6) To: 40 (in C6) Pick#: 6 (in D6) Pick# is the number of numbers in a set to be picked for the game. The settings entered will be used in the formula in B2: =randlotto(B6,C6,D6) Then just click the Draw button to generate as many random sets of unique numbers from within the range defined under "From" and "To" as desired. Generated sets of numbers will be frozen in col G from G2 down. One click of the Draw button generates one set. To reset / clear col G, just click the Reset button. The RandLotto UDF and the subs Draw and Reset for the 2 buttons described are listed in the "Notes" sheet The program's easy to use, and fun, too ! -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
random numbers, how can you utilize it without repeating them | Excel Discussion (Misc queries) | |||
random numbers from a data of numbers? | Excel Worksheet Functions | |||
Validating random numbers | Excel Worksheet Functions | |||
Random Numbers Change? | Excel Worksheet Functions |