"Ron" wrote:
The formula works but only for approx. 20 lottery tickets and then it
doesn't seem to check the rest. Am I doing something wrong?
It's almost as if it needs to be told to check them all???

Try these checks, in sequence ..
1. Check calc mode is set to auto (Tools Options Calculation tab, Check
"Automatic" OK)
2. Check that cells are not inadvertently pre-formatted as text (Format
Cells). If so, re-format the cell as General or Number, then re-confirm the
formula (click inside the formula bar, press Enter) -- you need to re-confirm
the formula before it'll work. Re-formatting alone will not trigger it.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---