so, it's the first 1000 unique entries or 1000 unique entries selected at
random? Thanks guys!

"Dave Peterson" wrote:

Autofilter works for all entries.

But it only shows 1000 unique entries in that dropdown list. You can still use
Custom and do a bit of typing to see what you want.

Debra Dalgleish offers some other work-arounds at:
http://contextures.com/xlautofilter02.html#Limits

Raj Mazumdar wrote:

Hi there... have a concept question... What is it meant when it is said that
the Auto-filter works for only the top 1000 entries? Does it mean:
a) The auto-filter works in only the top 1000 rows of records. So if I have
a record that doesn't occur in the top 1000 but occurs in the 1500th row say,
then that record won't be shown on the drop-down auto-filter.
...OR...
b) The autofilter shows only the top 1000 rows when there is an occurence of
a particular record in more than 1000 rows.

Please clarify... thanks

--

Dave Peterson