Considering the pick3 lottery, is it possible for Excel to look at a range
A:A (actual drawings) then compare with range, a pool of numbers, say B1:E10
(no blanks, random order) and in, say G1, display/predict the most likely
number from the pool that might show based on the past history.

If you need a sample please see
http://www.freefilehosting.net/download/3fg7a as it has the sample of the
hits in Sheet1 and the pool of Numbers are on sheet2. Green represents
Straight hits and Yellow are Boxed Hits.

Thank you Max for your help thus far.

It's a stretch and I know predicting lottery is out there.. to imposible. My
Pool however has an assortment of real hits and I can watch it but I never
know which one is the most likely.

Thank you for trying this.

Luke