All Or Nothing

[alsports2000]

Greetings. I am looking for a Texas All or Nothing Hit and Skip Chart. This is a brand new lotto game compost of 24 numbers(1-24) and you can only choose 12 numbers of the 24. The idea is to calculate which 12 will come up or which 12 will not show up. Its hard to keep up with this game cuz there are four draws per day and each is $2. I've played all four but I quickly learned that if you get 5,6, or 7 numbers correct, it does not pay you ANYTHING. Payouts: 8 numbers pays $2, 9-$10, 10-$50, 11-$500, 12-$250,000. Any help would be greatly appreciated. I've thought of just tracking one draw but I don't want to miss out on the others. Thanks. AL.

 

[PAB]

Hi alsports2000,

I assume you will be using EXCEL?
Where is your data situated in the WorkSheet?

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[PAB]

Hi alsports2000,

Let's assume that your drawn results are in cells E88 and continuing down.

In cell B1 enter the formula:

=COUNTIF(E8:E2008,">0")

In cells S5:AP5 enter numbers 1 to 24.

In cell S6 enter the formula...

=VLOOKUP($B$1,$S8:$AP2007,S$5)

...and copy across to cell AP6 ( This is the HIT & SKIP results ).

In cell S8 enter the formula...

=IF($E8=0,"",IF(COUNTIF($E8:$P8,S$5)>=1,0,S7+1))

...and copy across to AP8 and down to AP2007.

That's it!
Let me know how you get on.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.