Help me win the Lottery...

So I thought it would be interesting to leverage the help and insight of users on the forum to help build a Macro which would generate lotto #'s based on the results from the past 30 days.

Attached is a spread sheet of the New Jersey past winning lottery #'s...

The only thing I've done to it so far is use the "text-to-column" feature in excel to separate the #'s.

There are 30 rows of past winning numbers (30 past winning results).

Here's what I'm thinking my macro should do...

1. Go through each column and find

-The number that appears most frequent
-The number that appears less frequent
-The average of the column

And based on the average returned, pick a number but somehow correlate it to the most/less frequent number.

2. Go Across each Row and find the average of the Number

Do you guys know any cool data manipulation functions in Excel that would give more perspective on the data?

I intend to play the numbers and I will update this post with my results...

please share your thoughts.

lets get this money Baby!

Originally Posted by MarvinP

Hi Swade,

I wouldn't bet on the lotto as the odds are expensive. To learn Excel I'd play with the numbers. See the attached and see if you can figure what I've done.

Did you make excel pick a random # within the range of the row?

I doubt anyone would expect to win the lottery with excel but, a few thoughts...

Group the numbers and consider their frequency..primes, even/odd, deciles

Work out the number ranges to cover, say 50,000 lines and generate 6 random numbers. If you could consistently get the random line in your 50,000 lines i'd consider that a success.

=+OFFSET('Powerball Numbers'!$M$2,0,ROWS($A$1:A1),1,1)
=+SMALL(A2:B2,1)&-SMALL(A2:B2,2)
=+OFFSET('Powerball - 2Combos'!$D$1,COLUMNS($N$1:N1),0,1,1)
=+COUNTIF(N3:N1048576,2)
=+COUNTIF($C3:$G3,IF(ISNUMBER(VALUE(LEFT(N$1,2))),LEFT(N$1,2),LEFT(N$1,1)))+COUNTIF($C3:$G3,IF(VALUE(RIGHT(N$1,2))>=10,RIGHT(N$1,2),RIGHT(N$1,1)))

Use these formulas for lottery combinational play. [email protected]

Use summation, frequency and some other statistical tools