I'm hoping that you can help me complete the automation of my Pick 3 spreadsheet. Everything else in the spreadsheet has Excel formulas to complete what I want to do, but this set of tasks has stumped me.

Here's what I am trying to do:

1. Calculate the frequency of each digit (0-9) for the last 30 games.

2. Sort the digits by frequency. The top 3 are designated as "Hot" digits, the middle 4 are "Warm" and the bottom 3 are considered "Cold".

3. Record the 3 winning digits from each draw sorted according to frequency and record the pattern of Hot, Warm, Cold.

4. The sorted digits are assigned to a letter of the alphabet with "A" being the hottest digit and "J" being the coldest. The alpha code for the 3 winning digits is recorded.

5. A hit-and-skip chart of the Alpha values is created, such that a hit is given a zero and a skip adds one to the previously existing value.

It is the alphabetic values that seem to be interfering here, as my normal Excel formulas (e.g. for hit-and-skip) don't recognize the alpha equivalents.

I have uploaded a sheet to MediaFire to help you understand what I am doing:

**Pick 3 ON Frequency.xlxs**

**http://www.mediafire.com/?cv417drv1k7u420**

Thanks for looking at this.