Auto-filter option

R

Raj Mazumdar

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
 
R

Ron Coderre

The Excel autofilter dropdown list in the column headings will only display
up to 1000 unique items. All the data records will stil be displayed. There
are workarounds...but that's the basic limitation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
R

Raj Mazumdar

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

Dave Peterson

It looks to me to be the first 1000 unique values. But do a little
experimentation and you'll see how it works.
 
Top