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!