Following my Excel lottery number generator video I have had frequent requests for a Lotto 6/55 version. So here it is.
This spreadsheet demonstrates some fantastic Excel techniques, and as always the file is unprotected so that it can all be investigated.
The following Excel features are used:
- The RAND function is used to generate the random numbers
- The RANK and COUNTIF functions are used to rank the random numbers from 1 to 55 for retrieval of the balls
- The VLOOKUP function is used to retrieve the ball numbers
- Some VBA is used to perform the formula calculations when a button is clicked (Manual calculation has been chosen over automatic for the workbook)
I go through your Lotto 6/55 number generator, please tell me which way to activate the 6 button and the generator button. Thanks
The buttons function due to a Vlookup finding the number on the Calculation sheet.
The button works as it runs a macro that performs calculations on the sheet. Press Alt + F11 to open the Visual Basic Editor and view the code that the button runs.
This is necessary as Automatic Calculations have been switched to Manual Calculations on the sheet. This is done via the Formulas tab on the Ribbon.
why the button can not work …???
can’t run the macro”lottery_number_generator.xlsm!lotery_draw.
the macro may not be avaible in this workbook or all macros may disable
Sounds like the macros are disabled. In Excel 2010 a yellow message bar should appear with an Enable Macros button.
Otherwise click the File tab > Options > Trust Center > Macro Security and then the required option to enable them.
please help me with how to setup the draw sheet.
Thanks for your help
Mathew
This is great, but I will like to know how to edit and modify the codes to work with 5/59 numbers.
If you have the video that shows the steps please send me the link.
Thanks
Hi Muhammed,
Please check out this video on editing the lottery number generator spreadsheet.
http://youtu.be/SuL1q09jIpg
You Sir, As we Yanks say, Are Sh”#
Hot! Not enough Thank Yous’. If by some chance – good fortune should be fall me as a result of your sharing this program – your wife / Significant Other / Honey Bun is going to be a happy person, As you will no doubt be sharing in my good fortune. :>)Semper Fi Followed you instructions to the letter and it works like a charm.
You can maker for me generator number with ascending position 6/52 with plus bonus 52, 6/55 and 6/58.
can you help me, please, guys,how can i make a history for it? to see,for example, how many times was number 1. Please, very need it. thank you
o marcos mas eu gostaria de saber como não conseguir lottery fazer Excel 2007
Hello, Mr Murray.
What about if there is a requirement for a bonus number.?
How do you go about it.??
Thanks a lot for the help.
Regards,
Richard Lim
For the bonus number we can just add to the 6 numbers on the calculations sheet and then add an extra cell and Vlookup to return the 7th (or bonus) number.
What about if you already have the ranks for the lottery numbers? How can you generate the lottery? I tried using my state lottery ranking and the numbers will not generate.
The rank is just used to select the balls randomly.
have you got lotto5/90number generator spreadsheet if so please let me see it.
I don’t have a 5/90 number generator spreadsheet. This spreadsheet can be adapted for your needs though.
Hello Mr Murray,could you please help me adjust your spreadsheet to 5/90 number generator,i will so much appreciate it. Thank you
Hi Mr Murray,
could you please help me adjust your spreadsheet to 6/45 numbers generator ?
Thanks a lot for the help.
Hi Mostar,
Please check this video for an explanation for how it can be changed.
Lottery Number Generator Inside Out
Hi,
It’s very interesting…
Can you tell me if it’s possible to make a loterry with only some number presectionned please ?
What kind of code can i do to make this possible ?
Thanks in advance !
Phil
p.s. Sorry for my text…
i am deaf,,,please give me 6/55 only
Hello Mr Murray. Very elegant and nicely done. My question is how is possible to write every new calculation in different row in table on another sheet?
Thank you and have a nice day!
For example the Powerball and Mega Million have 5 numbers and 1 number generate separately from each drawing. Generating 6 numbers from each drawing to make up the bonus number will skew the result. What I did was to generate 5/75 and 1/15 for MM and 5/59 and 1/35 for PB from separate drawings in other not to skew the outcome. Please advice.
has anyone won with this recently?
If they have, I want a piece 🙂
Hi,
I have value not available error in b51 to b56
Why
Thanks
gud day mr. murray,
how about 3 digit..can you make it
a 3 digit for me, because here in our
country i always bet for 3 digit..
tnx from Philippines..
Hi Mr. Murray.
Good day to you
I’m from Malaysia. Can you make for 4 digit, because in our
country famous with 4 digit game.
You can view our country 4 digit game result in http://www.4d2u.com
Regards,
Jack
Hi murray. Am from mauritius,i’ve recently download the video of number genetator. Its fascinating. Hete in my country we play lotto of 6 numbers its quiet hard to find the correct 6 numbers. Is it possible that every time i generate the numbers i get all the possible outcomes? And if it is wright it must generates the past winning numbers. Just want to know if the generator will generate all the possible outcomes which is 38.380.000 ?
Hi Anoop,
I’m sorry this generator does not produce all of the possible outcomes.
Alan
Awesome work done by you. Will you help me by providing worksheet similar to Lotto. I am looking for a sheet which record and predict upcoming number. The game for which i am asking is based on 0-9 numbers (ones values only). Please reply how can I use lotto Sheet to create a new as per my required Sheet or send me the link if you have one of like that.
How do I store the generated numbers in a separate spread sheet automatically. Currently I have to manually copy the generated numbers and store them in a sheet. How it is possible to store the generated numbers automatically, please help.