Generate all combinations for Lotto Premier bet 5/90 and 4/52.

Solved
Riccilo Posted messages 15 Status Member -  
ccm81 Posted messages 11033 Status Member -
Hello,

I am looking for a solution to generate all possible lotteries premier bet combinations of 5 digits and then 4 digits, with the option to select combinations that I assume are potentially non-winning.
For example: if the winning number is 12345, it would be pointless to buy all the combinations 54321, 45321, 54312, 45312, 32451, ...

So I would like to obtain two Excel tables, the first of which will have combinations of 5 numbers from 1 to 90, without odd and even combinations and without permutations (vv-ww-xx-yy-zz / xx-zz-yy-ww-vv / yy-ww-xx-vv-zz / zz-xx-ww-yy-vv, ...), in the form of an Excel table.
The second table will have combinations of 4 numbers from 1 to 52, without odd and even combinations and without permutation (ww-xx-yy-zz / xx-zz-yy-ww / yy-ww-xx-zz / zz-xx-ww-yy, ...).

If anyone can help me create these Excel sheets with the integrated formulas.

Thank you in advance for your help and advice.

3 answers

  1. Alfred
     
    Chance has no memory...
    24
    1. Riccilo Posted messages 15 Status Member 22
       
      I know it sounds a bit crazy, but eliminating combinations with only even or odd numbers will significantly reduce the number of combinations. Even if there are only 200 combinations left, I'm ready to buy 200 tickets.
      2
    2. fermiparadoxx Posted messages 11454 Registration date   Status Member Last intervention   6 108
       
      Hello,
      Even combinations of only even, odd, or other numbers have exactly the same chances of coming out as any other draw.
      0
    3. Riccilo Posted messages 15 Status Member 22
       
      I noticed that the majority of the drawn combinations have three odd numbers and two even numbers, or two odd numbers and three even numbers.
      0
    4. fermiparadoxx Posted messages 11454 Registration date   Status Member Last intervention   6 108
       
      It's the word "majority" that is troubling in a statistic... This word has no place in probabilities...
      0
    5. Riccilo Posted messages 15 Status Member 22
       
      I tried to sort some numbers, is it possible to generate combinations of 5 numbers?
      Please.
      1