A vba code in excel 2023

[Krishnakovid143]

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

 

[StephenCrump]

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.

 

[Krishnakovid143]

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

 

[StephenCrump]

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

 

[Krishnakovid143]

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.

 

[Krishnakovid143]

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.

 

[Krishnakovid143]

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

 

[StephenCrump]

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.

 

[Krishnakovid143]

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

 

[Krishnakovid143]

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