Excel - Mega Millions Most Popular Numbers and Strategy - Episode 1911

[@theotisbrown8800]

Have you done an updated version for the current year, and have you ever won with this method.

[@MrXL]

I am up $590. I actually think the better strategy is to try to pick numbers that no one else is picking, to ensure that if you do hit, you aren't splitting the jackpot multiple ways. That is discussed here: kzbin.info/www/bejne/oJ6xZHuVrLCcb6c

[@Adriaan.J.L]

2:42 I think you should have tried using the mouth 😂😂😂

[@monp.4903]

Watching this in 2019! There are definitely very significant patterns in the lottery. I have been analyzing it. You can get the excel file of all the history from the Wisconsin lottery! lol

[@liufox1292]

This is glorious, I been tryin to find out about "what winning numbers are most popular in the lotto" for a while now, and I think this has helped. Have you ever come across - Menaleb Prefatory Method - (search on google ) ? It is an awesome one off guide for discovering how to find your lucky day to make you succeed in the lottery without the normal expense. Ive heard some great things about it and my mate got excellent results with it.

[@gnasa2102]

Thank you 💙 Can you please provide me the Power Query link version.

[@mickel6830]

What is the procedure to add additional dates and numbers to the existing tables to make it populate? Tried adding lines but they will not show from the first time set-up of the pivot tables.

[@myvn4ever]

Very good tutorial, and also, your voice is very soothing.

[@griffin5012]

This is great but how do you update all sheets and Pivot Tables if the original (raw) data is amended (i.e. new lines added to the source table)?

[@robinowen3899]

How do I find most popular numbers in each draw.

[@MrSunshanmu]

HI, I'M NOT GETTING THE SAME RESULTS WHEN I FOLLOW YOUR STEPS. IS THE PROCESS THE SAME FOR EXCEL 2019 VERSION 16?

[@todaysreality1575]

Did you win?

[@MrSunshanmu]

Hi is it possible to add data to the pivot table as it becomes available without starting the process from scratch?

[@MrXL]

Select a cell in the pivot table. On the PivotTable Analyze tab in the Ribbon, about half way across, there is a group called Data. The second icon there is Change Data Source. Click that, and you can edit that the data which used to go from A1:J999 now goes from A1:J1499 or whatever the new bottom row is.

[@burito1place448]

Can you Provide your finished chart to download? with pivot table? my Chromebook doesn't have a "PivotTable and PivotChart Wizard", nor could I edit my Pivot Tables, I would really appreciated. I learned a lot about Pivot Tables thanks

[@motleyassortment5512]

Thankyou for this tutorial. I am thinking of using Excel for keeping track of lotto, this will come in handy.

[@davidgreenidge2394]

Can you calculate the most common triplets or pairs.

[@woolysamoan]

Time for a new video, since they changed the number fields on us again on October 31, 2017. What a treat those tricksters gave us!

[@josestudyexcel]

Can you make a formula where it generates a series of lottery number combinations out of those most frequent numbers? Let's say I want to generate 50 lottery number combinations out of 18 frequent numbers.

[@jimnasium3208]

14:16 Someone up in 2019 lol It's cool that the most popular mega ball number shown in this video are still at the top of the list 5 years later.

[@MrXL]

+Chantley Wiese wow that is pretty wild and statistically significant.

[@devcrestha]

I want someone give me six Lottery numbers from 1-54.

[@jenseeman2527]

Thank you for teaching me about Pivot tables.

[@erikguzik8204]

ok... great great video (as always) you said someone from 2019 might be doing this... well how about 2022!!!! Yes, I should have done it before the 1.3Billion drawing. Want to know something odd. your video at time stamp 9:26 just filtering New Game. The #10 is the most popular number with 18, well in 2022 guess what the #10 is still the most popular with 129 (all be 56x it was the mega ball) but still funny. (Yes, smaller numbers are skewed because the Mega Ball doesn't' go as high) #31 is most popular now. Thanks so much for a fun video

[@arion343]

Hey sir, is it another way I could get in contact with you?

[@lisac6652]

what if you have a group of popular numbers can you find the combinations of the numbers example 123 132 213 231 321 ect...

[@MrXL]

I understand what you are trying to do. It is frustrating. Excel has functions that tell you how many combinations there will be. But they don't have anything to generate the list of combinations.

[@redmatrix]

14:15 Watching in Q4 of 2022!

[@jamesmhango2619]

ChatGPT?

[@mrbubetube]

The Iowa state lottery page has the megamillions numbers in a real nice tab delimited text file. Easy to import and no editing needed. www.ialottery.com/Results/MM.txt After you import, just use Bill Jelen's neat little pivot table trick to "unpivot" the data.

[@woolysamoan]

The Texas Website also has very good downloading data options. Many states are just pooping all over their players.

[@excelisfun]

Wow, that is so epic!!!!

[@liufox1292]

This is glorious, I been tryin to find out about "what winning numbers are most popular in the lotto" for a while now, and I think this has helped. Have you ever come across - Menaleb Prefatory Method - (search on google ) ? It is an awesome one off guide for discovering how to find your lucky day to make you succeed in the lottery without the normal expense. Ive heard some great things about it and my mate got excellent results with it.

[@kennykenaz8340]

This was great, I've been looking for "what are the luckiest lottery numbers?" for a while now, and I think this has helped. Ever heard of - Menaleb Prefatory Method - (search on google ) ? It is an awesome one off product for discovering how to find your lucky day to make you succeed in the lottery without the headache. Ive heard some great things about it and my friend got cool success with it.

[@JohnnyQuestFishing]

Currently 1 thru 70 numbers on Megamillions and 1 thru 69 on Powerball :D

[@OTuit]

Death to Data by pivot table. Hehe. Great stuff!

[@forecastinglottery6153]

only artificial intelligence seo8ceo.com can make an assumption about the numbers themselves and the date when this can happen