Not sure .. perhaps there's some data inconsistencies? Eg: some "numbers"
within the keyfilter col are not real numbers but text numbers. This would
apply to cols with "dates" as well, as real dates are just numbers. Assuming
the keyfilter col is not a formulas col, on a spare copy of the 1,026 entries
sheet, try selecting the entire keyfilter col, then click Data Text to
Columns Finish. This might suffice to convert all text numbers in the col
to real numbers (and convert text dates to real dates).

If the above doesn't do it .. perhaps post some examples of the data that's
within the keyfilter col, and explain how are you auto-filtering it.

Hang around awhile. Perhaps others would also offer their insights here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jooles" wrote:
Thanks Max, but that didn't work. I'm absolutely stumped at this point