How calculate these combinations ?

[The Wraith]

Me again, still counting combinations..
till now every given info here to me is working
and i learned a lot... but still not smart enough to find the next result..

so..

-- Got list lotto combinations (A1 till F3000)
-- List of 6 nr each line
-- All numbers from (1 to 42)

Now ...how can i calculate how much times off the 3000 lines these kind of combinations exists..

-- combination of 2 numbers
-- combi of 3 and 4 numbers

i think it's maybe to complex to make such a kind of program...
but maybe possible to calculate the combi of 2 numbers and
a (input cell) to check manualy for combi's of a 3th or 4th number ...out of the list


It would be kind of the one who knows a good solution to my problem
Greetings...

 

[erik.van.geit]

is this related to LOTTO ?

 

[erik.van.geit]

just saw your first post
it is related to lotto !!

a moment before I go further with this ...
what are you trying to achieve with this listing ?
what is your purpose ?

it is not my business what you're trying to do, but if you want somebody to created code to enhance your chances to win, it will not be me, since you cannot enhance your chances to win by any mathematical system
knoop dat goed in je oren

if you find it "ridiculous" to play this combination
1 2 3 4 5 6
then don't play lotto !

if you think you will get more chance by trying to find a system
then don't play lotto !!

if you think 7 12 24 33 38 41 has more chance to win then 7 9 11 13 15 17
then don't play lotto !!!

kind regards,
Erik

 

[The Wraith]

you send this message to everyone ?

I understand your opinion ...
but you send this to everyone who has tried to make some lotto formules..

My idee is just to analyze a bit the lotto system....if i will win or not ...it's allways better than not trying ...

But still looking for the VBA ...hahaha.. :wink:

i did some search myself allready and go to try this out...till next time....
when i got stuck i'll be back....
greetz...

 

[erik.van.geit]

Re: you send this message to everyone ?

I understand your opinion ...
but you send this to everyone who has tried to make some lotto formules..

My idee is just to analyze a bit the lotto system....if i will win or not ...it's allways better than not trying ...

But still looking for the VBA ...hahaha.. :wink:

i did some search myself allready and go to try this out...till next time....
when i got stuck i'll be back....
greetz...

YES, these last weeks I think three times (copies from previous post). It's curious people try to make systems. But there is no system !!! So it is NOT better then not trying. It doesn't make any difference to analyze the lotto, UNLESS the "machine" which generates the results is having some faults like
1. the "1"ball is heavier then the others
2. there is some magnetism in ball number "40"

when the lotto will be played for 1.000.000.000 years all combinations will have occured about 10.000 times (52.000.000.000 weeks 5.245.786 combinations)

suppose you are "throwing a die" in Excel

Sub throw_die()
Randomize Timer
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) = Int(Rnd * 6) + 1
End Sub

results
4
4
4
4
what's the chance to throw again a 4, you think ?

when i got stuck i'll be back....

always ready to help "for the sport"
you will need "memory-calculations" if you do not want to wait an eternity for your results

best regards,
Erik