View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How many entries can Excel handle!?

If that's the problem, try the advice at
http://www.contextures.com/xlautofilter02.html#Limits
--
David Biddulph


"Dave Peterson" wrote in message
...
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