One other thought would be to check the ("tie-breaker"?) formula
that's in: Overall!$AP:$AP

What exactly is the formula that you have there ?
Where does the formula start and end?

If the formula's starting in mid-stream in col AP, i.e. not from row1 down,
then it's safer to use the exact range in col AP instead of (albeit neater)
entire col references. If you use entire col refs, then ensure that there's
nothing in col AP above the starting cell which could be throwing the
correct extracts off (look for especially other numbers unrelated to what
you're extracting with the posted formula).
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--