List all combinations of 6/36 with unique 4 numbers

[Martin888]

Hello!

I've been looking at this all over the internet, and either I'm the first one that looks for this or I can't word it properly... I can't find anything.

I would like Excel to give me all the possible combinations of a 6/36 lottery, but only to win the 4 out of 6 numbers. There should be around 320 combinations.

For example these would be valid combinations:

1 2 3 4 5 6
1 2 3 7 8 9
1 2 4 10 11 12

These wouldn't be valid:

1 2 3 4 5 6

1 2 3 4 5 7

2 3 4 6 10 11

because "1 2 3 4" and "2 3 4 6" are appearing twice.

I hope someone will be kind enough to point me to the right direction. Please let me know if my explanation isn't clear.

Thanks a bunch!

Martin

[Iantaylora]

Sorry, the win and loss conditions are kind of unclear here... if I'm reading you correctly what you need is all permutations, then to detract any in which more than four numbers match, is that basically the idea? How high do the numbers go? I'm a math major and I think I can help but the wording is a bit confusing, so let me know if I'm on the right track

[Martin888]

Thank you for replying to my question I'll try to be as clear as posssible, my native language in French, so it happens that I can't find the exact term to describe what I want

in a 6/36 game (6 numbers from 1 to 36 that doesn't repeat), the chances to get 4 numbers out of 6 is 1/320. I'm looking for a script that can give me all the 320 combinations (I know there are more than that, but if you start with a set of numbers in particular, if I understand properly, there will only be 319 extra combinations that can come out of that one)

Because in reality, these would all be different combinations:
1,2,3,4,5,6
1,2,3,4,7,8
1,2,3,4,9,10

but for what I want, only 1,2,3,4,5,6 needs to be shown, since 1,2,3,4 has already been used, therefore cannot be used again. 1,2,11,12,13,14 would be a good combination, but after I get this one, I cannot have any that have 1,2,11,12 or 2,11,12,13 or 11,12,13,14 or 1,11,12,13 or 1,11,12,14 or 2,12,13,14 or 1,2,12,13 or 1,2,13,14.

Does that make more sense? Let me know if you need more clarification

Thanks!

Martin

[Kyle123]

There are more than that by my reckoning:
=COMBIN(36,4)

But I think I probably misunderstand

Just because the chance of winning is 1/320 doesn't mean there are only 320 combinations

[Martin888]

I completely agree with you, there are more than 320 combinations, but if you start with 1,2,3,4,5,6 and you exclude all the combinations that has these "range" in it: 1,2,3,4 & 2,3,4,5 & 3,4,5,6, then at the end, I would assume you would get 320 combinations. But if you would start with
2,3,4,5,6,7, then you would get a completely different batch of 320 combinations (because 1,2,3,4,5,6 wouldn't be valid since 2,3,4,5 has already been "used")

Does that make sense?