A vba code in excel 2023

Krishnakovid143

New Member
Joined
Feb 17, 2025
Messages
7
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I need to find 6 number combinations from 54 numbers and I want to elminate all of the consecutive numbers like 1 2 3 4 5 6-51 52 53 54. 55 56 and only combinations greater that sum 20,can anyone help me please I am new to coding
 
Welcome to the Forum!

If your numbers are the sequential integers 1, 2, 3 ... 53, 54, then every combination will have sum > 20 (unless you want to allow repeats?)

Even without repeats, you'll have nearly 26 million combinations. There seems little point in listing these in a worksheet - you can carry out any analysis you like without enumerating every possibility.
 
Upvote 0
i can and i also have a limit i can only analyze it if i find the max,and i can want to elminate 5,346 numbers that will never repeat,so what will be my best solution,i am only trying to find out the missing numbers,my basic idea was to elminate consecutive numbers,put them in between a range so ican elminate a lot of combination,please suggest,thank you.i heard people crack things using this website
 
Upvote 0
if i find the max ... want to eliminate 5,346 numbers that will never repeat .... trying to find out the missing numbers ...
It sounds like you want to carry out an analysis of previous draw history (rather than all possible draws) in the belief this will help you predict the more likely numbers/combinations in future draws.

But you'll need to explain in more detail what you're trying to do in your analysis.

i heard people crack things using this website
Yes, indeed, but I can guarantee you that doesn't include next week's lottery draw: Gambler's fallacy - Wikipedia
 
Upvote 0
It sounds like you want to carry out an analysis of previous draw history (rather than all possible draws) in the belief this will help you predict the more likely numbers/combinations in future draws.

But you'll need to explain in more detail what you're trying to do in your analysis.


Yes, indeed, but I can guarantee you that doesn't include next week's lottery draw: Gambler's fallacy - Wikipedia
i know sir i read up on all the 156 fallacy so i wont be fooled,i am trying to build a system for more than 5 numbers so i can elminate it and i do not depend on luck i depend on math and i also am not trying to play like dumb people expecting to put 1$ and become a millionare overnight,i have my own calculations,i just wanted to generate a vba code that can help me in this,i am willing to pay if the code works with all the limitations i mention,i do not want to waste anyones time for my work.thanks,and i am a re multi on paper its so illquid so i am trying to make liquid,so i have started with small numbers,this system is for future.sorry if the post is too long.
 
Upvote 0
i am trying to elminate all previous numbers,consecutive numbers,and put them in between a range by analysis on min and max for all the 32years,i also want to reduce the odds by playing more numbers,i beleive that statistics do not apply to finite numbers and i cannot beat probability so i am incresing odds of winning,i am confident because i did go through numbers manually for all the years and they were no repitations for another game,not 54 numbers but with less numbers,i am not spouting ninsense it took me 3 days full to prove my theory that they wont repeat.
 
Upvote 0
i am trying to elminate all previous numbers,consecutive numbers,and put them in between a range by analysis on min and max for all the 32years,i also want to reduce the odds by playing more numbers,i beleive that statistics do not apply to finite numbers and i cannot beat probability so i am incresing odds of winning,i am confident because i did go through numbers manually for all the years and they were no repitations for another game,not 54 numbers but with less numbers,i am not spouting ninsense it took me 3 days full to prove my theory that they wont repeat.
reduce* increase
 
Upvote 0
i have my own calculations,i just wanted to generate a vba code that can help me in this

What do you want the VBA code to do? You'll need to be specific. Terms like "eliminate all previous numbers", "5,346 numbers that will never repeat" and "missing numbers" are too vague.
 
Upvote 0
i will think more on it and get back to you tommorow,thank you for your patience with me,i will write down all the criteria from this minute and post it
 
Upvote 0
I cannot find anything more than the criteria like 1)missing numbers 2)duplicates to determine favorite numbers 3)sum of range of numbers 4)remove already winners from 32yrs,max and min range I am sorry if I troubled you I just wanted the system to be easy but my system makes 2times as much everyday it’s capital intensive but for a random game that’s the max you can get some days it’s 4.18 times,hope I can get the code somewhere or I will try using previously written codes
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,918
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top