xl2003 and below will only show 1000 unique entries in the autofilter dropdown.

But you can use a custom filter and type in what you're looking for (use
contains???).

Rebecca Sage wrote:

I have close to 1000 entries in my Excel spreadsheet, and am trying to figure
out why entries are coming up missing. I often do custom sorts. This may be
when entries get tossed out?

--

Dave Peterson