Im looking for a way to generate 5 lottery numbers (between 1 and 39) whilst excluding a list of previous winning numbers. The list of previous winners would be very long and contain several years of data, so id like excel to create a five digit number that did not contain any previous winning sequences.
Hello! Is it possible (and how) to introduce in the =randbetween formula the database (the location of it) of the drawn numbers? I mean, the 6 numbers to be extracted according to the previous drawn numbers' frequency. Thank you.
HI FOR THE DELTA SYSTEM METHOD, I ALSO READ ABOUT AND IT SAID All the following examples assume a 6-digit, 1 to 50 lotto game. These rules will change somewhat for games which are too different from this - for Powerball or Megamillions, for example, 18 to 22 would be the top delta number. I DID A SIMPLE MATH CALCULATION TO FIND OUT WHAT THE TOP DELTA NUMBER WOULD BE FOR A 5/35 SYSTEM AND FOUND 11. I'M NOT 100% THAT IT'S CORRECT BUT I DID THE CALCULATION FOR THE 1 TO 50 AND THEN FOR EXAMPLE THE MEGA MILLION IS 1 TO 70 AND GOT 11 BOTH TIMES. SO I WENT WITH ELEVEN. WHAT I WANT TO ASK IS HOW DOES IT CHANGE WHEN THESE NUMBERS ARE DIFFERENT? FOR EXAMPLE YOU FIRST PICK A NUMBER BETWEEN 1 -5 THEN 1 - 8 THEN ONE CLOSE TO 8 THEN TWO NUMBERS BETWEEN 8 AND 15, 6 TOTAL. HOW DOES THAT CHANGE WHEN IT'S A 5/35 SYSTEM. WHAT RANGE WOULD YOU SELECT THOSE NUMBERS? THANKS IN ADVANCE. LOVE YOUR TUTORIAL BTW SIMPLE AND EASY TO UNDERSTAND.
Hi Tim, That would definitely be a different function than shown in this video. I'll work on creating a video showing a couple of options you may want to consider.
Hi Paul - not sure what e-book you're referencing, but the WikiHow article link I mention in the video is: www.wikihow.com/Choose-Lottery-Numbers. I do have a Excel courses available - For a 50% Discount on the "Managing Data" full course, click here: mailchi.mp/204eae493313/57vyeppxmu
@@goaskdebbie you say at the end of your vid that you have a free e-book with 65+ thing to with office,you say to click on the link ,but you have not put a link...
@@Paul998-B Thanks for letting me know, Paul - sorry, the guide was moved here: mailchi.mp/c4164c62ad2f/65-ways-to-use-ms-office-to-be-more-productive-ebook
Albert - if you're looking to have the numbers show on a different page, you'd want to do some sort of link like = and then the sheet and cell that you want to appear on the new page. With these formulas I've shown, they are really meant to show on the existing sheet to give you a list of random numbers for the lottery games you play.
how can you change one number and have all of the same numbers change example if my list 1 2 3 4 5. When I change any one of numbers all the matching numbers in the list would change as well.
Hi George Z - the functions are set to randomize every time, so you would have to copy and paste value on the numbers you want to keep and then select another random number.
@@goaskdebbie choose another random number if you take into account that the lotto does not fall out by chance, but as a result of the forecast of the RNG of the organizers, then rss * rss
*4WinLottery. Com* is a well known lotto winning approach you can search on Google. It had been a week ago ever since I found out about it and I truly find it wonderful! With this particular plan, you will know how to get all the resources necessary to gain more than "$352" every day by winning lotteries . What are you awaiting? Give it a go today!
Madam, I'm looking something like a group of six number each number could input selected or range number for each six number than find possibly combination to generated. Pls reply thank you.
This was great, thanks, I been tryin to find out about "is lotto decoded a scam" for a while now, and I think this has helped. Have you ever come across - Zenulian Lottify Bonkers - (just google it ) ? Ive heard some awesome things about it and my brother in law got excellent results with it.
@@varadarajuluparthasarathy3451 Can you upload to Facebook? My page would be a great spot so that others can benefit as well. Here is the GoAskDebbie page: facebook.com/GoAskDebbie/
I've provided a way to select numbers; there is no guarantee of winning from these functions. It''s also just a fun way of showing how to use some of the Excel functions.
Hi Donnie! I mention in the video that it's just a way of getting random numbers and it's not perfect - again, just a way that Excel can help you randomize numbers.
Thank you for sharing
You’re welcome! What other topics would you like to see?
@@goaskdebbie Great video. Thanks for sharing. I would like you to do a topic on Accounts in Excel to manage your business and personal finances
How do I get the ebook?
What way could the frequency charts be used in these formula to choosing the most likely drawn numbers?
Did you manually group the like numbers together for option #3 or is there an auto sort function that does this?
Yes, UberMesch - you will need to Sort the numbers first or the =COUNT function will not count them correctly.
Thank you madam, it was really helpful your video, thanks
Respectfully;
Andy
Thank you - glad I could help!
I want someone give me six Lottery numbers from 1-54.
THANKS
If you use randbeteen in a row, than sometimes it takes two times the same number, so its not working for lottery
Im looking for a way to generate 5 lottery numbers (between 1 and 39) whilst excluding a list of previous winning numbers. The list of previous winners would be very long and contain several years of data, so id like excel to create a five digit number that did not contain any previous winning sequences.
How do play lottery game that has 1 to 30 numbers?
You can use =RANDBETWEEN(1.30)
Hello!
Is it possible (and how) to introduce in the =randbetween formula the database (the location of it) of the drawn numbers? I mean, the 6 numbers to be extracted according to the previous drawn numbers' frequency.
Thank you.
It's not possible to use the specific numbers & frequency using =randbetween, but you can specify a range.
HI FOR THE DELTA SYSTEM METHOD, I ALSO READ ABOUT AND IT SAID All the following examples assume a 6-digit, 1 to 50 lotto game. These rules will change somewhat for games which are too different from this - for Powerball or Megamillions, for example, 18 to 22 would be the top delta number. I DID A SIMPLE MATH CALCULATION TO FIND OUT WHAT THE TOP DELTA NUMBER WOULD BE FOR A 5/35 SYSTEM AND FOUND 11. I'M NOT 100% THAT IT'S CORRECT BUT I DID THE CALCULATION FOR THE 1 TO 50 AND THEN FOR EXAMPLE THE MEGA MILLION IS 1 TO 70 AND GOT 11 BOTH TIMES. SO I WENT WITH ELEVEN.
WHAT I WANT TO ASK IS HOW DOES IT CHANGE WHEN THESE NUMBERS ARE DIFFERENT? FOR EXAMPLE YOU FIRST PICK A NUMBER BETWEEN 1 -5 THEN 1 - 8 THEN ONE CLOSE TO 8 THEN TWO NUMBERS BETWEEN 8 AND 15, 6 TOTAL. HOW DOES THAT CHANGE WHEN IT'S A 5/35 SYSTEM. WHAT RANGE WOULD YOU SELECT THOSE NUMBERS?
THANKS IN ADVANCE. LOVE YOUR TUTORIAL BTW SIMPLE AND EASY TO UNDERSTAND.
Hi how can i find all combinations of 20 of my favorite numbers
Hi Tim, That would definitely be a different function than shown in this video. I'll work on creating a video showing a couple of options you may want to consider.
Can u tel mahzooz lottery formula 5 balls 49 numbers
How to select 1 to 49 Balls please select 6 digit numbers
Hi Debbie,how can i get the e-book, theirs no link to click on...
Hi Paul - not sure what e-book you're referencing, but the WikiHow article link I mention in the video is: www.wikihow.com/Choose-Lottery-Numbers. I do have a Excel courses available - For a 50% Discount on the "Managing Data" full course, click here:
mailchi.mp/204eae493313/57vyeppxmu
@@goaskdebbie you say at the end of your vid that you have a free e-book with 65+ thing to with office,you say to click on the link ,but you have not put a link...
@@Paul998-B To receive my FREE eBook: 65+ Ways to Use Office to be More Productive, CLICK HERE: eepurl.com/c5_uID
@@goaskdebbie Thats for that but it just says This information is not available.
@@Paul998-B Thanks for letting me know, Paul - sorry, the guide was moved here: mailchi.mp/c4164c62ad2f/65-ways-to-use-ms-office-to-be-more-productive-ebook
How did you use for in 3pick if the lotto has 49 to play 6? numbers
Hi
how to display your lottery numbers on a separate page
Albert - if you're looking to have the numbers show on a different page, you'd want to do some sort of link like = and then the sheet and cell that you want to appear on the new page. With these formulas I've shown, they are really meant to show on the existing sheet to give you a list of random numbers for the lottery games you play.
How to create all 5 combinations from specific numbers?
Hi Be3eeLtd - to created with specific numbers, simply use the =RANDBETWEEN and use the number that are specific to your lottery.
how to use excel to get lottery result in excel
How do you find the program for a diamond grid.. using pick 3 4 5 draws?[
How to select 1 to 39 Balls please select Lacky balls 6 digit
how can you change one number and have all of the same numbers change example if my list 1 2 3 4 5. When I change any one of numbers all the matching numbers in the list would change as well.
Hi George Z - the functions are set to randomize every time, so you would have to copy and paste value on the numbers you want to keep and then select another random number.
@@goaskdebbie choose another random number
if you take into account that the lotto does not fall out by chance, but as a result of the forecast of the RNG of the organizers, then rss * rss
I've different 1 to 35 numbers should be 10 no.in row how we can make this combination
*4WinLottery. Com* is a well known lotto winning approach you can search on Google. It had been a week ago ever since I found out about it and I truly find it wonderful! With this particular plan, you will know how to get all the resources necessary to gain more than "$352" every day by winning lotteries . What are you awaiting? Give it a go today!
Where is the link of the file? Thumbs down...
Hi Jossi - the video simply shows you how to use a couple of different functions in Excel to randomize numbers. There is no file that is referenced.
HOW DO YOU USE EXCEL TO REARRANGE THE NUMBERS?
Plz make a video in hindi from india
Madam, I'm looking something like a group of six number each number could input selected or range number for each six number than find possibly combination to generated. Pls reply thank you.
This was great, thanks, I been tryin to find out about "is lotto decoded a scam" for a while now, and I think this has helped. Have you ever come across - Zenulian Lottify Bonkers - (just google it ) ? Ive heard some awesome things about it and my brother in law got excellent results with it.
hi, can you please explain how number 364 became 139570 in excel
Were you using the =RAND function? or something else?
Thanks for your response, I tried RANDBETWEEN function but i don't get the result. please explain.
@@varadarajuluparthasarathy3451 Can you post what your formula was and what the result was? A screenshot, possibly?
@@goaskdebbie Hi, mai i send the excel file to your email, because i don't know how to attach excel file here.
@@varadarajuluparthasarathy3451 Can you upload to Facebook? My page would be a great spot so that others can benefit as well. Here is the GoAskDebbie page: facebook.com/GoAskDebbie/
Hey Miss my lottery Emirates 1 to 49 so how can I hundle and win tell me
Hi Mehar, Use the =RANDBETWEEN and use the range of 1 to 49. Good luck!
@@goaskdebbie can you send what's up number I talked to what's up
Can somebody tell me how to do step 3 in excel 2016? Thanks
Hi Rol - are yo talking about the 3rd example I show =COUNT?
How do you use this for pick 3
For Pick 3, you would just need 3 numbers for your random numbers.
goaskdebbie can you please explain how can i do step 3 in excel 2016 thanks
i've never heard of anyone who won the lottery with the delta system
I've provided a way to select numbers; there is no guarantee of winning from these functions. It''s also just a fun way of showing how to use some of the Excel functions.
And you NEVER WILL, cause it doesn't work..
randbetween sucks because it doesnt remove for the numbers you have selected.. there will be duplicate numbers.
Hi Donnie! I mention in the video that it's just a way of getting random numbers and it's not perfect - again, just a way that Excel can help you randomize numbers.
HOW TO MAKE THIS SIMPLE COUNT NUMBER IN EXCELL . YOU DO NOT EXPLAIN OR SHOW HOW ....
167"/
I want someone give me six Lottery numbers from 1-54.
3 11 23 42 50 53
Bernadette Cairn Thank you very much.
How to select 1 to 44 Balls please select 7 digit numbers