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
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.
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.
OK, that looks good. But what if I have a historical list of previously drawn Lottery numbers already drawn on an Excel sheet, and now I want to eliminate those numbers from future draws, do you know of a way I can apply this to the random number generator?
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.
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 ^_^
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!
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
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
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% :)
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.
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.
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.
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.
Hello, Is it possible to have another sheet, where previously drawn numbers came out are listed, and be a consideration for what numbers come out when the draw button is click?
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!!
So based on the functions you created in columns A and B, how do you calculate not using certain numbers. In other words, the changes of last week's winning numbers repeating themselves are not truly random, no matter what the math gurus say. I would prefer to subtract those numbers before doing any calculations.
Winner of a video, I been tryin to find out about "best lotto system" for a while now, and I think this has helped. Have you ever come across - Zenulian Lottify Bonkers - (do a search on google ) ? Ive heard some decent things about it and my friend got excellent success with it.
Why is it that there are a small handful of people who have won the lottery multiple times,while the rest of us never seem to ever win? Here is the answer: tinyurl.com/lottowin55
This was great, thanks, been searching for "how to play to win the lottery" for a while now, and I think this has helped. Ever heard of - Zenulian Lottify Bonkers - (should be on google have a look ) ? Ive heard some awesome things about it and my m8 got cool success with it.
Friends Do you want to know the secret of winning a lottery…. Here is the the link that helps you to win your next lottery… > t.co/LuW1m5oJ3r?2AEc5BicD9kdg
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!
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
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.
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.
Hi, Thank you for the video. How can I change this document, so that I don't have 1 draw button, which produces 6 random numbers, but instead make it so that each box has it's own draw button and then ensure that the numbers don't duplicate? I was able to create different draw buttons, but can't figure out how to avoid duplicate numbers. Thank you,
You want to put the calculation for the rand function cells in a loop so that they calculate until that return a number different to the ones in the other 5 cells.
Hi there! Have enjoyed your video immensely but I am far from understanding how to create a number generator! I would love to have my own detail-specific generator! I would like to to have the ability to fix the first, third, and last number according to my command. Also, I would like my logo to be included! If you could assist me or maybe design this for me could you please reply asap with all the details!! Thanks
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
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..
It should be B2 really. 11 years old this video. I had to look to see what you were referring to. That formula provides a unique ranking by counting the occurrence of a number.
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
Is there an excel file that can compare all six past winning numbers to your future picks so you don't pick the same winning number as it would probably not show up again. Thanks for your help.
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!!!
I have tried to do what you did in your excel document (but for 50 numbers instead of 49), however it seems that the new version of Excel creates formulas that look different than how yours does. It says that the formula is incorrect. I can't work out why it isn't going through. When I mimic what you did on the 'Draw' Page it looks like the formula below and says 'there's an error in the formula you entered'. For your information 'Lotto Randomisation' is the name on the tab that I gave my 'Calculations page' =VLOOKUP(Calculations!'Lotto Randomisation'!$E$1,Calculations!'Lotto Randomisation'!$B$2:$C$51,2,FALSE)
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 am using OpenOffice Calc and I'm having problems setting the DRAW spreadsheet. I don't find the options to create a numbers generator button. No DEVELOPER neither a FORMULA tabs.
You can download the file from a link in the video description. This file can be edited to meet your needs. Check out my channel for another video that demonstrates how to make these changes.
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.=)
This is just superb, I been tryin to find out about "lottery number pattern finder" for a while now, and I think this has helped. You ever tried - Zenulian Lottify Bonkers - (search on google ) ? Ive heard some great things about it and my mate got amazing results with it.
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?
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:)
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
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.
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
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.
Followed your instructions, my button moves up and down, but nothing happens i.e. numbers don't change. At the very bottom left of excel window I see the words "ready" and "Calculate". If I use that word "Calculate" alternately with the button, the numbers change. What did I do wrong? Thanks.
Sir is there any help from you to create a group of six numbers and all six numbers individually set selected number to generated possible combination.
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?
+celiazora Yes the program could be set up to rank the numbers sequentially. That could be added to the code without too much problem. Yes to the other question too.
is there a way of building one of these that works from existing data? so say you took all of the euro millions results in.history. entered them into the sheet and then asked it to generate 4 possible outcomes foe the results based upon the existing data sets? one for the main numbers and one the bonus ball sets? it would be interesting to see how a random generator stacked up against a full data generator to see if there was any correlation.
Enjoyed the video. Have the calculation page working. the Draw set up. No problem, however the Button I'm getting a subscript out of range message. Review the macro, seems to be ok. I do have a number of of numbers. I have 165 instead of 50. Please advise.
Double check the ranges used in the macro and the typing of the sheet names etc. The subscript out of range error indicates that it cannot understand the cell of range of cells you mention.
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.
Good day sir, can you make me a lottery number generator in 6/42 or 6/49 and can remind me that all six past winning numbers had already drawn so you don't pick the same winning number? Thank you so much
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.
I have tried to do what you did in your excel document .It says that the Argument not optional. I can't work out why it isn't going through. When I mimic what you did on the 'Draw' Page it looks like the formula below and says 'there's an error in the formula you entered'. For your information I have use following steps to create lottery number generator in VBA MACRO DRAW PAGE & error shown by system : steps : Sub Button2_Click() calculations("calculations").I Range("A2,A50").calculations With statements("DRAW") Range ("C7"), calculations Range ("E7"), calculations Range ("G7"), calculations Range ("I7"), calculations Range ("K7"), calculations Range ("M7"), calculations End With End Sub Errors: 1) Argument not optional 2) --------------------------- Microsoft Visual Basic --------------------------- This command will stop the debugger. --------------------------- OK Cancel Help --------------------------- EXCEL SHEET FORMULAS FOR CALCULATIONS WORKSHEET RAND UNIQUE RANK BALL NUMBER 1 2 3 4 5 6 =RAND() =RANK($A2,$A$2:$A$50)+COUNTIF(B$1:B1,B1)-1 1TO49 FOR DRAW WORKSHEET C E G I K M =VLOOKUP(CALCULATIONS!E1,CALCULATIONS!B2:C50,2,FALSE)
Try File > Options > Trust Center > Trust Center Settings > Macro Settings. It should say Disable macros with notification. This will mean a yellow bar called the Message Bar appears when you open the file. You will need to click the Enable button on it.
I'm getting a N/A on one of my draw numbers randomly. It says value not available error. I did notice that if I take it of manual calculations and put it back to automatic it doesn't produce the N/A error. Any way to fix this
Thanks for sharing, I couldn't get it to work quite right. I am getting run-time error 9, subscript out of range. Do you know where I am doing mistake? Thanks.
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.
Would you be able to make a custom version of this with our logos etc on the Draw sheet? The main issue is that we offer have between 600 to 2500 entries
Hey, the CountIf function does not work in eliminating duplicates in the Unique Rank column. For it to have the desired effect you need to separate the Ranking and CountIf functions into separate columns, and have the countif copy directly from the Rank cell at the same level (not the previous cell). I.E Ranking Calculation in Cell B2 =Rank(A2,$A$2:$A$50) Unique Rank Calculation in Cell C2 =B2+CountIf(B$2:B2,B2)-1 You would then use column C for the Unique Rank You can't have the above calculations in the same cell, as this creates a circular reference.
This was great, I have been researching "lottery number combination systems" for a while now, and I think this has helped. Have you heard people talk about - Zenulian Lottify Bonkers - (just google it ) ? Ive heard some great things about it and my mate got excellent success with it.
Hi, I am trying to create a random sampler generator for a list of names associated with a random file numbers. My goal is to be able to automatically pick a number of samples (from the random file numbers associated with the names - similar to this lotto drawing concept to maintain integrity in picking the files for quality control) I would like to know if I can use this concept and if you can show what formula to add to associate random number to a specific name?
+Bliss Spice Yes you can use the same technique for what you wish. If you have a list of the numbers and associated name. You can do the same setup as this lottery number generator to generate the random number. Then the only difference is having a VLOOKUP to return the name associated with it.
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
@@Computergaga Crazy necro post, but when I tested by manually entering 2 identical decimal values in the rand() col (A), the ranking didn't work for me. I had to change the "+countif" portion from B's to A's to get it to work (ie: refer the countif portion of the formula back to the rand() column. Sincerely hope I'm not confusing things after all this time. Appreciate the tip though!
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
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.
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.
OK, that looks good. But what if I have a historical list of previously drawn Lottery numbers already drawn on an Excel sheet, and now I want to eliminate those numbers from future draws, do you know of a way I can apply this to the random number generator?
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.
its been 6 years, have you hit it already? Lol
If I win the 6/42 PCSO Lotto jackpot with this formula, I will give this channel some money.
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 ^_^
Only in PC right?
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!
Awesome. Thank you Rune.
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
could you please set up a combination mix from 1 to 22 in groups of 5. thanks
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
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% :)
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.
After setting Calculation Options to Manual, you can simply press the function key F9 to re-calculate. Saves having to write the macro.
True, the macro can be used to run specific formulas though.
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?
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.
For Excel 2011 you need to click the Excel menu > Preferences > Ribbon. Then check the Developer check box and click Ok.
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.
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.
Good work Sawirus.
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.
Hi can you please tell me why I am getting Run Time Error 9 saying subscript out of range. How do I fix it
The RND function can be used in VBA for similar purposes and then displayed on the sheet without the need for the Lookup functions.
Hello, Is it possible to have another sheet, where previously drawn numbers came out are listed, and be a consideration for what numbers come out when the draw button is click?
@@richmadrid9563 Sure. It is not something that I have an example to demonstrate. But yes it's possible.
@@Computergagaactually i don't have laptop can u tell the formula about mahzooz draw 49 numbers 5 balls
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!!
the creative ideas and solutions in excel like this video are better than depending on standard methods.
many thanks
So based on the functions you created in columns A and B, how do you calculate not using certain numbers. In other words, the changes of last week's winning numbers repeating themselves are not truly random, no matter what the math gurus say. I would prefer to subtract those numbers before doing any calculations.
Winner of a video, I been tryin to find out about "best lotto system" for a while now, and I think this has helped. Have you ever come across - Zenulian Lottify Bonkers - (do a search on google ) ? Ive heard some decent things about it and my friend got excellent success with it.
If you want a really easy method for winning the lottery then go here now: HotLotto.xyz
Why is it that there are a small handful of people who have won the lottery multiple times,while the rest of us never seem to ever win? Here is the answer: tinyurl.com/lottowin55
This was great, thanks, been searching for "how to play to win the lottery" for a while now, and I think this has helped. Ever heard of - Zenulian Lottify Bonkers - (should be on google have a look ) ? Ive heard some awesome things about it and my m8 got cool success with it.
Friends Do you want to know the secret of winning a lottery…. Here is the the link that helps you to win your next lottery… > t.co/LuW1m5oJ3r?2AEc5BicD9kdg
I am not too familiar with OpenOffice but was under the impression that it did have functions such as CountIf
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 looks interesting but does this thing take into consideration previous lotto draw results?
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!
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
Hi ,can you please tell me how did you create the draw sheet design? Thanks 🙏🏻
They are just cells that have been resize and had their fill colour changed. VLOOKUP brings over the numbers.
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 ?
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.
Denise C. A very different problem. This is just 6 random numbers.
@@Computergaga Any formula integration tips as to how to generate that please
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.
Hi,
Thank you for the video.
How can I change this document, so that I don't have 1 draw button, which produces 6 random numbers, but instead make it so that each box has it's own draw button and then ensure that the numbers don't duplicate?
I was able to create different draw buttons, but can't figure out how to avoid duplicate numbers.
Thank you,
You want to put the calculation for the rand function cells in a loop so that they calculate until that return a number different to the ones in the other 5 cells.
Thank you, I am not so skilled in this. Can you send me a link or video that would explain this please?
Hi,I have my own simple pick 3 system on paper.can you help me build a software online for it, please.
Hi there! Have enjoyed your video immensely but I am far from understanding how to create a number generator! I would love to have my own detail-specific generator! I would like to to have the ability to fix the first, third, and last number according to my command. Also, I would like my logo to be included! If you could assist me or maybe design this for me could you please reply asap with all the details!! Thanks
Couldn't really say without seeing your code. Property is information about an object such as a cells value.
Are you able to send this program that is already completed by email?
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
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..
It should be B2 really. 11 years old this video. I had to look to see what you were referring to. That formula provides a unique ranking by counting the occurrence of a number.
@@Computergaga thank u so much for ur prompt reply. Good Day, God Bless.
Greetings. How do you ensure that the numbers are displayed in ascending order after they have been generated?
I wnet to your website and got the second page and adjusted it the way I wanted and it is all goo now.
Thx
@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
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
Is there an excel file that can compare all six past winning numbers to your future picks so you don't pick the same winning number as it would probably not show up again. Thanks for your help.
Not that I have.
thank you very much Mr Computergaga great excel sheet for numbers i give 7 stars
Thank you, Raymond.
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!!!
How is the rank function used?
Hi @computergaga, can we set our own manual Unique Ranking. I want to rank the numbers according to the frequency data that I have.
I have tried to do what you did in your excel document (but for 50 numbers instead of 49), however it seems that the new version of Excel creates formulas that look different than how yours does. It says that the formula is incorrect. I can't work out why it isn't going through. When I mimic what you did on the 'Draw' Page it looks like the formula below and says 'there's an error in the formula you entered'. For your information 'Lotto Randomisation' is the name on the tab that I gave my 'Calculations page'
=VLOOKUP(Calculations!'Lotto Randomisation'!$E$1,Calculations!'Lotto Randomisation'!$B$2:$C$51,2,FALSE)
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?
such a genius!!!! i love it!!! I hope one day I'll win and I will recognize you then.
Thank you, Abi.
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 am using OpenOffice Calc and I'm having problems setting the DRAW spreadsheet. I don't find the options to create a numbers generator button. No DEVELOPER neither a FORMULA tabs.
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.
Very easy to follow. Great work mate!!
Thank you Du Nguyen.
I am really interested in your workheet. Do you have soft copy? Or how can I download ? I need random of 36 balls that get only 6 ball winning. Thanks
You can download the file from a link in the video description. This file can be edited to meet your needs.
Check out my channel for another video that demonstrates how to make these changes.
am wondering if we can use this for random musical tones.....chords, 12 tones etc...but its too confusing
I'm not familiar with musical tones, but if you're generating random data, then yes.
how will i be able to know that, the random numbers generated are the possible upcoming numbers? it finally worked. Thank you.
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.=)
What do you use bro?
amers83 you need all winning lottery numbers from day one and enter into generator.
This is just superb, I been tryin to find out about "lottery number pattern finder" for a while now, and I think this has helped. You ever tried - Zenulian Lottify Bonkers - (search on google ) ? Ive heard some great things about it and my mate got amazing results with it.
only artificial intelligence based on self-taught neural networks can solve the problem of lottery forecasting
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?
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.
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:)
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 Afzal, I have created a video. I hope it helps - ua-cam.com/video/1GDgTN4lvAo/v-deo.html
If I wanted to have button for 5 numbers and a button for 1 number ex: 1-70 and 1-18. How would I set that up. I can't seem to figure it out?
Excellent job 🎉🎉
Thank you! 😃
Fort to say thank you....I learned something new in Excel
Thank you as I have learned some new tricks in Excel :)
Your welcome Peter, thank you.
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.
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
Good stuff.. now, lets say your lotto has numbers from 1-28. Can this produce all the possible sets of 6 numbers.?
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.
Hi how did you make the lottery number generator ive done the spread sheet as you said . regards Damo
Can we use the numbers that are mostly winners? Instead of 1,2,3, etc can we use 26.11.20. 19, etc?
Followed your instructions, my button moves up and down, but nothing happens i.e. numbers don't change. At the very bottom left of excel window I see the words "ready" and "Calculate". If I use that word "Calculate" alternately with the button, the numbers change. What did I do wrong? Thanks.
Lets say I have a list of 20 numbers. Is there a way to sort all the numbers to create a list of all possible combinations?
Sir is there any help from you to create a group of six numbers and all six numbers individually set selected number to generated possible combination.
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?
+celiazora Yes the program could be set up to rank the numbers sequentially. That could be added to the code without too much problem. Yes to the other question too.
+Computergaga can you tell me that how to make list of 75 numbers please please please
is there a way of building one of these that works from existing data? so say you took all of the euro millions results in.history. entered them into the sheet and then asked it to generate 4 possible outcomes foe the results based upon the existing data sets? one for the main numbers and one the bonus ball sets? it would be interesting to see how a random generator stacked up against a full data generator to see if there was any correlation.
Yes, this would be possible. But not something I have done.
@@Computergaga I could fire you an excel sheet with all the data present if you fancy a pop at it?
@@LeonPhythian69 thanks, but I won't have a chance to play with this.
thanks I will use this and see if I win anything, I will keep you posted.
Enjoyed the video. Have the calculation page working. the Draw set up. No problem, however the Button I'm getting a subscript out of range message. Review the macro, seems to be ok. I do have a number of of numbers. I have 165 instead of 50. Please advise.
Double check the ranges used in the macro and the typing of the sheet names etc. The subscript out of range error indicates that it cannot understand the cell of range of cells you mention.
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.
Can you make a video for pick 3 lottery ? But it would not be random...we would have a list of numbers that this generator would provide.
Good day sir, can you make me a lottery number generator in 6/42 or 6/49 and can remind me that all six past winning numbers had already drawn so you don't pick the same winning number? Thank you so much
Hi, can you do same excell program but with 10 from 80 numbers? Or is there?
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.
I have tried to do what you did in your excel document .It says that the Argument not optional. I can't work out why it isn't going through. When I mimic what you did on the 'Draw' Page it looks like the formula below and says 'there's an error in the formula you entered'. For your information I have use following steps to create lottery number generator in VBA MACRO DRAW PAGE & error shown by system :
steps :
Sub Button2_Click()
calculations("calculations").I Range("A2,A50").calculations
With statements("DRAW")
Range ("C7"), calculations
Range ("E7"), calculations
Range ("G7"), calculations
Range ("I7"), calculations
Range ("K7"), calculations
Range ("M7"), calculations
End With
End Sub
Errors:
1) Argument not optional
2)
---------------------------
Microsoft Visual Basic
---------------------------
This command will stop the debugger.
---------------------------
OK Cancel Help
---------------------------
EXCEL SHEET FORMULAS
FOR CALCULATIONS WORKSHEET
RAND UNIQUE RANK BALL NUMBER 1 2 3 4 5 6
=RAND() =RANK($A2,$A$2:$A$50)+COUNTIF(B$1:B1,B1)-1 1TO49
FOR DRAW WORKSHEET
C E G I K M
=VLOOKUP(CALCULATIONS!E1,CALCULATIONS!B2:C50,2,FALSE)
I am able to make this sheet and saved it however macros are not allowing access, what should I do to fix this issue, thxx
Try File > Options > Trust Center > Trust Center Settings > Macro Settings. It should say Disable macros with notification.
This will mean a yellow bar called the Message Bar appears when you open the file. You will need to click the Enable button on it.
thxx alot, helped me access :)
Computergaga I wrote the same thing check it out bro...maybe we can collaborate!
I'm getting a N/A on one of my draw numbers randomly. It says value not available error. I did notice that if I take it of manual calculations and put it back to automatic it doesn't produce the N/A error. Any way to fix this
Thanks for sharing, I couldn't get it to work quite right. I am getting run-time error 9, subscript out of range. Do you know where I am doing mistake? Thanks.
There is an error somewhere in your range reference.
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.
Would you be able to make a custom version of this with our logos etc on the Draw sheet? The main issue is that we offer have between 600 to 2500 entries
Hello, Thank you for this video. Could it be posible to use the same calculator entering last winning numbers?
LOURDES RIVERA-SANCHEZ
I was wondering this same thing-there must be a formula you could include that excludes previous winning combos?
That would be perfect. Or at least compare frequency on past numbers individually. I think I am asking a little too much lol.
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
Hey, the CountIf function does not work in eliminating duplicates in the Unique Rank column.
For it to have the desired effect you need to separate the Ranking and CountIf functions into separate columns, and have the countif copy directly from the Rank cell at the same level (not the previous cell).
I.E
Ranking Calculation in Cell B2
=Rank(A2,$A$2:$A$50)
Unique Rank Calculation in Cell C2
=B2+CountIf(B$2:B2,B2)-1
You would then use column C for the Unique Rank
You can't have the above calculations in the same cell, as this creates a circular reference.
You have commas in your code instead of full stops.
Also the Calculator sheet is called Calculations in the tutorial.
How add random numbers cumulatively? every time a random number is generated it adds up with previously generated number and sum is displayed.
Thanks for sharing....learned a lot and will learn more
Brilliant! You're welcome.
Hi could you tell me how can make draw sheet please
This was great, I have been researching "lottery number combination systems" for a while now, and I think this has helped. Have you heard people talk about - Zenulian Lottify Bonkers - (just google it ) ? Ive heard some great things about it and my mate got excellent success with it.
Hi, I am trying to create a random sampler generator for a list of names associated with a random file numbers. My goal is to be able to automatically pick a number of samples (from the random file numbers associated with the names - similar to this lotto drawing concept to maintain integrity in picking the files for quality control) I would like to know if I can use this concept and if you can show what formula to add to associate random number to a specific name?
+Bliss Spice Yes you can use the same technique for what you wish. If you have a list of the numbers and associated name. You can do the same setup as this lottery number generator to generate the random number. Then the only difference is having a VLOOKUP to return the name associated with it.
you are so cool man! Do you have any ways to direct to use VBA to random 6 numbers and the show in spreadsheet?
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
Sir, it is possible to create a interface that contains measurements and information pertaining to input lotto bet slip for print any home printer.
I'm having trouble with the rank formula can it be given to us here so we can put this in correct?
This is the rank formula Kimberly.
=rank($A2,$A$2:$A$50)+countif(B$1:B1,B1)-1
@@Computergaga Thanks so much. I really would love to win the lottery soon.
@@Computergaga Crazy necro post, but when I tested by manually entering 2 identical decimal values in the rand() col (A), the ranking didn't work for me. I had to change the "+countif" portion from B's to A's to get it to work (ie: refer the countif portion of the formula back to the rand() column. Sincerely hope I'm not confusing things after all this time. Appreciate the tip though!