Stuck on Excel formula

Reply #8

Just6ntlc — Thu, 01 Mar 2007 04:42:05 GMT

That's a great possibilities on number occurrences.

Reply #7

johnph77 — Mon, 26 Feb 2007 05:50:11 GMT

Sum chart for 5/56+1/46 lottery matrix:

``````````````````````````````````````````````````````016```````017```````018```````019```````020

```````````````````````````````````````````````````````````1`````````2`````````4`````````7````````12

----------------------------------------------------------------------------------------------------

````021```````022```````023```````024```````025```````026```````027```````028```````029```````030

````````19````````29````````42````````60````````83

Reply #6

johnph77 — Fri, 23 Feb 2007 04:52:36 GMT

Correction:

Sum 198 - 1,309,852 occurences.

Sum 166 - 1,833,414 occurences (most frequent).

Sum 163 - 1,828,041 occurences.

Program results not yet confirmed with spreadsheet analysis.

gl

j

Reply #5

johnph77 — Thu, 22 Feb 2007 14:29:40 GMT

JAG331 -

The program I set up was for a specific sum rather than a range. The programming could be redone, and it's simple coding, just like I had originally done to provide a check on my sum charts. It never occurred to me to set up a sum chart to include the bonus ball for the more popular two-field games such as PowerBall and MegaMillions, but it can be done.....

gl

j

Reply #4

JAG331 — Thu, 22 Feb 2007 14:06:28 GMT

John, thanks for the info. Do you have any advice on how to create these filtering programs

Reply #3

johnph77 — Wed, 21 Feb 2007 15:32:49 GMT

I ran a quick program on the 5/56+1/46 matrix with a sum of 198 - if I'm correct there are 1,309,852 combinations that meet that criteria. Without going into the rest of the programming I would think the most popular sum would be around 163 or thereabouts, and there would be 1,833,414 combinations with that sum.

gl

j

Reply #2

JAG331 — Tue, 20 Feb 2007 17:32:29 GMT

This is something that I could use help with also, the ability to create filters.

Reply #1

phileight — Tue, 20 Feb 2007 02:09:38 GMT

Griz

I understand you want to enter a number in cell a1, generate a unique 5 # comb with numbers between 1 and 56, plus 1 # between 1 and 46, then compare the total to value in a1, if it matches keep it else do next comb.

I think you will need a VB program within excel to do this. some one here can probably tell you how many hundred thousand combinations match your criteria. with such a huge volume of possible comb why not use the rand function to generate comb then select from that lis... [ More ]

Stuck on Excel formula

Griz — Sun, 18 Feb 2007 19:16:04 GMT

Hi ya'll,

I'm having a bit of a problem with trying to make up a formula for my project, hoping someone can help.....what I need is this..

Take a number say 198, in cell A1 for example..

I need a formula which will list all the possible 6 number group combinations utilizing the number range 1 thru 56 for the first 5 groups and the number range 1 thru 46 for the 6th number group which when added up will total

198, examples:

22 33 35 40 53 15 = 198

or

5 9 15 21 32 9 = 91

Numbers in the... [ More ]