Using Excel 2010
Hello,
In the game of Euromillones there are 2,118,760 possible combinations of 5 different numbers. Without 2 stares (or without 2 bonus ball) if one could play all combinations that guarantee jackpot price.
I want a VBA that generate all combinations guarantee for 4 correct. May that could be some 1,000,000 or guarantee for 3 correct. May that could be some 10, 000 combinations I am not sure.
Does anyone know is it possible?
Regards,
Moti
I have no knowledge about this game at all, but I found a website about this game along with an Excel file related to it. Hopefully, it will be helpful to you.
https://exceldoodling.home.blog/2019...millions-xlsx/
Quang PT
Hello bebo021999, thank you giving a time and searching a solution for me.Originally Posted by bebo021999
What you have searched it is just a euromillons lottery checker.
Normally euromillons has =COMBIN(50,5) = 2118760 total combinations without adding 2 stars (or 2 bonus number).
I want code that generate all possible full combinations = 2118760 apart of that code must have option to find combinations =COMBIN(50,4) = 230300, =COMBIN(50,3) = 19600 & =COMBIN(50,2) = 1225.
I did search but do not find any VBA that can do this job.
Have a nice day good luck.
Kind Regards,
Moti
You do know that this is a fool's errand, don't you? Trying to outwit pure chance is pure folly.
There's another member who has asked for help with combination generation in probably 100 or more different ways over the past 4-5 years here, and so far he has failed to win anything significant. And he won't win anything significant by trying to second guess the order in which balls will be drawn - it's a sheer waste of time.
My advice: don't waste your time.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello AliGW, I respect your advice and you have reason, I am aware lottery is pure random and pure luck game one can buy one line combination can get huge amount and another can buy 1000 of line combinations get 0 price.My advice: don't waste your time.
I just wanted a VBA and check it virtually does excel =COMBIN(50,2) = 1225 line combinations have 2 correct if any number drawn among all possible combinations.
Please if anyone can help I appreciated.
Kind Regards,
Moti
Is this what you want ?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Wow JohnTopley, you nailed it. Perfect solution I am getting of my entire questions answer just changing in the (Sheet1 cell A2...value 2, 3, 4 and 5 numbers)
I admire a lot your help.
Have a nice day good luck.
Kind Regards,
Moti
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks