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)

Download the Lotto 6/55 number generator spreadsheet.

P.G.Mathew Tharakan says

I go through your Lotto 6/55 number generator, please tell me which way to activate the 6 button and the generator button. Thanks

computergaga_blog says

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.

chandra says

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

computergaga_blog says

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.

Chris Davies says

please help me with how to setup the draw sheet.

P.G.Mathew Tharakan says

Thanks for your help

Mathew

Muhammed says

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

computergaga_blog says

Hi Muhammed,

Please check out this video on editing the lottery number generator spreadsheet.

http://youtu.be/SuL1q09jIpg

Old Dog says

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.

Zamri says

You can maker for me generator number with ascending position 6/52 with plus bonus 52, 6/55 and 6/58.

eddy says

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

marcos says

o marcos mas eu gostaria de saber como não conseguir lottery fazer Excel 2007

Richard says

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

computergaga_blog says

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.

Sterlian Nash says

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.

computergaga_blog says

The rank is just used to select the balls randomly.

majaliwa says

have you got lotto5/90number generator spreadsheet if so please let me see it.

computergaga_blog says

I don’t have a 5/90 number generator spreadsheet. This spreadsheet can be adapted for your needs though.

ABRAHAM says

Hello Mr Murray,could you please help me adjust your spreadsheet to 5/90 number generator,i will so much appreciate it. Thank you

mostar says

Hi Mr Murray,

could you please help me adjust your spreadsheet to 6/45 numbers generator ?

Thanks a lot for the help.

computergaga says

Hi Mostar,

Please check this video for an explanation for how it can be changed.

Lottery Number Generator Inside Out

Gomes Philippe says

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…

jigs says

i am deaf,,,please give me 6/55 only

Mont says

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!

Muhammed says

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.

Diana says

has anyone won with this recently?

computergaga says

If they have, I want a piece 🙂

micosmiling says

Hi,

I have value not available error in b51 to b56

Why

Thanks

Rolando says

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..

jack says

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

Anoop says

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 ?

computergaga says

Hi Anoop,

I’m sorry this generator does not produce all of the possible outcomes.

Alan

Dheeraj Kumar says

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.

Vishal says

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.