LOL Bernd!

Not hardly a doctor.. I am just poking around at the pick three lottery and
although I know I would never get close to any serious wins I like to see how
things play out given the past history.

Probably should have mentioned that but I didn't want the nay sayers to
intervene. It clouds things up.

"Bernd P" wrote:

Hello Luke,

A naive and pragmatic historical lookback needs your definition of the
"horizon" you want to take for the lookback.

A horizon of 1 day lookback would just give you the last number in
A14: 3. That's MODE(A14)
A horizon of 5 days: MODE(A10:A14) would result in 1.
The full history of 14 days MODE(A1:A14) would give you 2.

So it might make sense for you to look at the array
MODE(A14)
MODE(A13:A14)
MODE(A12:A14)
....

But I hope that you are not a doctor who will take this scheme to
predict the desease of his next patient :-)

Regards,
Bernd