Create an Excel Lottery Number Generator 

I actually came here to watch about generating lottery numbers (I thought the video was about wheeling systems) but I actually learned something new in Excel, so thanks very much, now subscribed to your channel

Thank you followed up your instruction and ended up generating five number out of 15 for euro lottery and It works straight away , no complication no problem instead of 49 number I chose 15 numbers from A2 to A16 which generate five number out of 15 I protected the Vlookup furmulas and the Rand and rank I can change the 15 numbers in the the C column anytime saved it on macro Brilliant and very helpful. I have my own GENERATOR now I may come back one day and tell you I hit it. lol Thank you again.

If I win the 6/42 PCSO Lotto jackpot with this formula, I will give this channel some money.

Bob, You need a period before each Range object so the main section reads; With Worksheets("DRAW") .Range("C7").Calculate .Range("E7").Calculate .Range("G7").Calculate .Range("I7").Calculate .Range("K7").Calculate .Range("M7").Calculate End With

Many thanks to Computergaga with your tutorial. Now i already made myself a complete lottery number generator 6/42, 6/45, 6/49 and 6/55 without any errors. You are such a great help to us. God bless you my friend ^_^

You can either create a different button to click for each ball. The manual calculation VBA code for the ball would be assigned to each button. Or you can run this line of code every 3 seconds or something by using the ONTIME method in Excel VBA. Check it out.

Very nice! Thank you! I made a version with names of the Employees in stead of numbers. Some people with more than one chance in the lottery. Live lottery at work!

The draw sheet is just 6 cells that have been formatted with a fill colour and border. Vlookups are then entered to capture the data from the Calculations sheet. The file can be downloaded from the downloads section of my website.

Great. This generator does not assume that the numbers generated will be the upcoming numbers. They are completely random. If they do happen to be the right numbers and you win. I would like 50% :)

You will need to insert a conditional statement such as If inside the loop to test if the number has already been produced. If so then select another number at random

For Excel 2011 you need to click the Excel menu > Preferences > Ribbon. Then check the Developer check box and click Ok.

the creative ideas and solutions in excel like this video are better than depending on standard methods. many thanks

RANDBETWEEN is the answer as you say. This sheet performs the calculation on the click of a button. Automatic formulas have been switched off for this to happen. Download the workbook and check out the VBA code that runs the formula.

It is entered =rand() and produces a random number between 0 and 1. On the spreadsheet the cells are formatted in a white font in that column. This may be why you are not seeing the numbers.

thanks I will use this and see if I win anything, I will keep you posted.

Couldn't really say without seeing your code. Property is information about an object such as a cells value.

Yes certainly. Please check out my Excel Lottery Generator Inside Out video for instructions.

The RND function can be used in VBA for similar purposes and then displayed on the sheet without the need for the Lookup functions.

I am not too familiar with OpenOffice but was under the impression that it did have functions such as CountIf

I wnet to your website and got the second page and adjusted it the way I wanted and it is all goo now. Thx

Fort to say thank you....I learned something new in Excel

For anyone need a 6/55 version of the lottery number generator. This can also now be downloaded from a link in this videos description.

Thank you so much for putting it up for downloading! I edited it to create a random rank of order of attacking in a D&D type game.

So cool! Thank you for sharing. It took me an hour to create it because I was making silly mistakes and my version of excel is different. I plan to fully utilize this lottery number generator. Look for me on the news...LOL!!!

The best and the only way a lottery number generator can work, is a program that keeps track on the draws, and picks the new numbers based on the best records on how late and how soon the numbers were drawn. So, it makes the new games matching the best ratios of even odds, lower, medium and high numbers, that matches the best rations of soon&late numbers. Still, even with the best programs, any system can guarantee that we´ll win everyday, but this is the best one to keep playing.

Man, I wish I was smart enough for this. I'm alright at narrowing down the numbers that won't come up by half on my own just by looking at patterns and eliminating cold numbers based on feelings.However, I would love generator that lists every combination for the rest of them. Millions of combinations to go through but I would be a little bit closer.=) I'm having fun doing this. It's a never ending challenge. Probably the same buzz people get chasing after Big Foot.l.o.l.=)

such a genius!!!! i love it!!! I hope one day I'll win and I will recognize you then.

After setting Calculation Options to Manual, you can simply press the function key F9 to re-calculate. Saves having to write the macro.

thank you very much Mr Computergaga great excel sheet for numbers i give 7 stars

how will i be able to know that, the random numbers generated are the possible upcoming numbers? it finally worked. Thank you.

Thank you as I have learned some new tricks in Excel :)

But, it's not what I was looking for. However, this is just as brilliant . What I was looking for in Excel, but have failed many times myself is that, after the lottery numbers have been selected by the machine from the rolling wheel or whatever machine it is, I then write all those 6 winning number in boxes at 6:00 that are similar to what you're done in this video, but I play the same number, so I write all the ticket's six numbers in each rows straight on Excel. The lottery game is six winning number out of 45. When any of the six number from the machine are selected, that are the winning numbers and then I use those number to check the ticket for winning numbers. But it would have been much easier if I typed the winning number in those 6 boxes (6:00) and then I click on 'Find' or 'Enter' and the winning numbers then highlighted in every rows of the entire ticket numbers written in Excel, according to what they are, e.g. row 1 would have 3,12, 26 highlighted. Row 3 would have 12 (again) and 31 highlighted as is row 1, while row 7 would have 4, 9, 27, 31, a measly win of 4 numbers in row 7, usually $24, depending on what lottery you play. The other rows might have a couple of highlighted numbers, or only one number. This is what I have been trying to do but it doesn't do to my expectation. Only one number is highlighted on only one row, not 2 or 4, or six numbers in one row, or any numbers in other rows below. How do I make this thing highlight whatever 6 winning numbers from every row in the ticket that has been written on Excel? Since I use the same numbers, how can I type six winning numbers in a six box finder and then hit Find or Enter

This is just a simple light hearted random number generator for picking numbers for the lottery.

Alan your tutorial vedios are very clear and helpful. Thank you very much. I have created in excel ball number frequency of the lotto but I do not know how to work out how many days ago those ball numbers were last drawn. Would you be kind to guide me what formula to use and how to work that out please. Thank you.

one last question is there any formula where we can use historical data of winning numbers to at least predict two winning numbers? i'm really impressed with ur software! thank you

Excellent job 🎉🎉

this looks interesting but does this thing take into consideration previous lotto draw results?

Hey just saw the vid, if you still haven't figured it out all you have to do is add in between the Range("C7").Calculate and Range ("E7").Calculate input this code Application.Wait Now + TimeSerial(00,00,01) or however many seconds you'd like to wait between drawing

Very easy to follow. Great work mate!!

Powerball Lotto choses 6 numbers from two different baskets, so I modified the VBA code by adding another With Statement and another sheet to generate numbers for the Powerball. The first With Statement generates 5 numbers and the second generates a Powerball. Thank you.

You have commas in your code instead of full stops. Also the Calculator sheet is called Calculations in the tutorial.

Good use for the rank function! Thanks for sharing this.

could you please set up a combination mix from 1 to 22 in groups of 5. thanks

24,5,4,18,13,26 31,16,19,7,1,10 25,22,13,27,33,15 What is the next series Plz tell me sir Numbers between 1 to 35 only

Awesome, loved every minute of it EXCELLENT CHANNEL

This is pretty awesome! I'm actually wondering, is there a way to modify this to use for a raffle drawing? I'm trying to do a raffle with my employees but seeing as we're all working from home right now, I'm not sure how to go about this in the most fair way possible. Any pointers would be greatly appreciated!

This looks like fun. I must try this.

What will happen if when you mark your card and after you get home you have repeat numbers on you card. If That number is draw do they have to pay you twice because you paid for the number twice you should get paid twice. Or Will it Void The ticket all together

does the actual lottery take into consideration the last lottery result? The chances of the balls being the same 2 weeks running is exactly the same as getting completely different ones, or 1,2,3,4,5,6 even.

I absolutely love this tutorial and created everything exactly as you explained but for some reason my button is not working. Maybe I have done something wrong in the formulas? Could that be? Please help!!

If we have 58 Lottery Draw Results then how comes we can calculate what formula does the drawer using to generate the Results. If there is anything plz reply

Hello ! The =randbetween is helpful in this case, but if I want the numbers to be generated according to the previously drawn numbers' frequency, how would =frequency formula be implemented? Thank you.

Thanks for sharing with us 💕❤️

Absolutely

How can I add a function where it also references previously drawn numbers on an additional spreadsheet so not to repeat those numbers in addition?

great wee video.. thx... ok so we now got our numbers... would their be a way to get them in numerical order.. low to high ?

The boxes are just the cells formatted to look like boxes.

Hi Austin, I have sent you an email with a 6/55 edition of the lottery number generator.

I was able to create my own generator with your example. This was cool! My question is how how do you take into consideration the numbers that have already been drawn? That must be a different problem to solve.

Thanks for sharing....learned a lot and will learn more

Nice intelligent man

Hi how are you you are great thank you so much you take care have a nice day

in picking 5 random numbers from 1-35, i know there are 324,000 combos, how do i generate a complete list of all the 5 number combinations?

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

Loved the walkthrought... I just have 1 question though when i was using the countif function I was not able to do that. so i skipped the countif function given around 3:25 and went ahead.. My only question is I used numbers from 1 to 39 .. my only question is why were we using cell B1 in that formula..

Vid of the day! Thank you 4 sharing.

Thank you for the tutorial. Need to know that if I have last 7 days results, how can I fetch out next day probable result.

This is a very good system. I have tried the system on the database I made up and seems to work fairly. Just a question, when I close the macro file and try to reopen, it cannot find it and indicating the file is not available or disabled. The button does not work.

Greatly appreciate if you can tell me how to make the number generated appear on individual ball, instead of all 6 balls at once. Thanks.

How do you save the generator file/button so that next time you open, it will be able to find the macro without giving error message.

Wow! This is timeconsuming. I don't have the patience. Do you have the instructions written in narrative form, so I can follow step-by-step. Following the video is very difficult. Thank you

I need to follow these exact steps on my spreadsheet, but I need to make sure that nothing will change the random numbers EXCEPT the button. In other words, I need to enter and delete information on the same spreadsheet...and while I do this, I need the random numbers to remain the same. And then when I'm ready, I will hit the button to change the random numbers. You didn't enter or delete anything after making the button, so I'm not sure if this is possible. Let me know. Very helpful video:)

Very helpful. great tutorial. cheers

@computergaga, have you try using formula =randbetween(1,49) for first 6 balls instead of number 1-6. To be more random. And use that in vba also

But please show as if your want to setter according to dates for example if the lottery is playing to day how can i set number for today

It is working, i hope i hit the correct sequence.

This is a pretty cool app. Thanks. I was wondering if I wanted to get some random numbers between 1 to 12 in the same file. So the generator will draw two sets of numbers, 5 between 1 to 49 and then 2 between 1 to 12. How would I go about that?

Good stuff.. now, lets say your lotto has numbers from 1-28. Can this produce all the possible sets of 6 numbers.?

Nice demonstration of Excel use but I don't understand how this can be regarded as a true Lottery number generator if it is possible for the same number to appear more than once and then have Excel manipulate it so it appears unique. Surely then it is not random. When lottery numbers are drawn, the odds of the first number are 1/49, the second, 1/48 and so on.

I never use excel, so I did ok creating the first page, I could nt get the draw page to work at all. I need more instructions on how to set up the "draw Page" itself, starting with setting up the page and the cells themselves. Should they be calculation cells, output cells etc. First page good, second page, stuck. Thanks

Can we use the numbers that are mostly winners? Instead of 1,2,3, etc can we use 26.11.20. 19, etc?

Can you change column to an integer not a decimal number.

Good Work ....

Sir I want to know. Is there any formula if I type a number or any word in a cell and when I retype the same number or word in any cell of that entire row it shows I m clinging to type duplicate or I find a msg such like that the value I want to type is already exists. It should only be a single row not for entire excel sheet

Hi Sir That was awesome your video. could you please advise is this format can develop by using past draw results as well? please.

i like you worksheet....anything for wheeling the numbers i want.....doing it manually now

Hi ,can you please tell me how did you create the draw sheet design? Thanks 🙏🏻

Sir, I'm looking for a group of six numbers and each individual of six numbers could input selected or range of numbers to generated possibly combination and list all combination automatically with a single click.Pls reply thank you.

I think to calculate past result just enter the past number in place of ball 1-6

It seems I made a wrong fomula. but I can't see it. Can you help me? from 1-45. Thank you!

This was really cool and it came out perfect. Question: How can I do one that will generate a 4 digit number from 1000 to 9999? I already know how to do the randbetween. But I want to do it like this because it's a lot classier. Thanks!

Hello can you help me

What is the reason for not unhiding the Calculations worksheet in the down load? Might help some folks. Just sayin'.

am wondering if we can use this for random musical tones.....chords, 12 tones etc...but its too confusing

This is a great tool. We are wondering if there is a possibility that the generator will return the same set of six numbers but in a different order and consider that a unique set of numbers. Can the randomizer be programmed to rank the numbers sequentially?

Greetings. How do you ensure that the numbers are displayed in ascending order after they have been generated?

Thank you. Well made.

excellent brother

i have row with numbers 1,0,1,1,1,0,1,0,0,1,1,1,1 who is even longer if i look in history. is there any whey in excel what can help me find next number according of previous data, maybe there is some macro who can read history data and when it ends continue independently to make numbers according of previous data. Or you know better whey how i can get solution of this problem. hope you can help me. Thank you for your other videos they are really useful.

How can this macro be updated with the 6th draw from a pool of 25 balls? Thank you.