Strange Results with Autofilter

[Peter Bernadyne]

Thank you very much for your responses. However, it is neither of these
problems.

I have no hidden rows or columns and the column I am filtering on is
contiguous from Row1 to Row60001 (so if I Ctrl+DownArrow or
Ctrl+UpArrow, I navigate immediately to the beginning and end).

Also, the full date is in the column I'm filtering on (10/31/2002) as
it is with the other dates (about 520 others, monthly observations -
only one day and year per month so all Oct-2002 would have to come from
Oct-31-2002). Trying to filter on any one of these dates, however, is
producing only 60-or so results as opposed to the thousands I should be
getting.

I know this all sounds like there must be something very simple that
I'm overlooking, but I'm pretty sure I've checked all the basics. It's
so weird that I'm willing to send you the file to look at it, if you
like - although I don't want to waste any more of your time, in the
process.

 

[Debra Dalgleish]

If you'd like to zip the file and send it to me, I'll take a look at it.
(Remove the XSPAM from my address)

Let me know what criteria you're selecting, and what results you expect.