software

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
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:
contextures.com/xlautofilter02.html#Limits

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

--

Dave Peterson

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-Proquot;Raj Mazumdarquot; wrote:

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

Hi Ray

You can find information here
www.contextures.com/xlautofilter02.html#Limits--
Regards Ron de Bruin
www.rondebruin.nlquot;Raj Mazumdarquot; gt; wrote in message news
gt; Hi there... have a concept question... What is it meant when it is said that
gt; the Auto-filter works for only the top 1000 entries? Does it mean:
gt; a) The auto-filter works in only the top 1000 rows of records. So if I have
gt; a record that doesn't occur in the top 1000 but occurs in the 1500th row say,
gt; then that record won't be shown on the drop-down auto-filter.
gt; ...OR...
gt; b) The autofilter shows only the top 1000 rows when there is an occurence of
gt; a particular record in more than 1000 rows.
gt;
gt; Please clarify... thanks
gt;
gt;
so, it's the first 1000 unique entries or 1000 unique entries selected at
random? Thanks guys!

quot;Dave Petersonquot; wrote:

gt; Autofilter works for all entries.
gt;
gt; But it only shows 1000 unique entries in that dropdown list. You can still use
gt; Custom and do a bit of typing to see what you want.
gt;
gt; Debra Dalgleish offers some other work-arounds at:
gt; contextures.com/xlautofilter02.html#Limits
gt;
gt; Raj Mazumdar wrote:
gt; gt;
gt; gt; Hi there... have a concept question... What is it meant when it is said that
gt; gt; the Auto-filter works for only the top 1000 entries? Does it mean:
gt; gt; a) The auto-filter works in only the top 1000 rows of records. So if I have
gt; gt; a record that doesn't occur in the top 1000 but occurs in the 1500th row say,
gt; gt; then that record won't be shown on the drop-down auto-filter.
gt; gt; ...OR...
gt; gt; b) The autofilter shows only the top 1000 rows when there is an occurence of
gt; gt; a particular record in more than 1000 rows.
gt; gt;
gt; gt; Please clarify... thanks
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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

Raj Mazumdar wrote:
gt;
gt; so, it's the first 1000 unique entries or 1000 unique entries selected at
gt; random? Thanks guys!
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Autofilter works for all entries.
gt; gt;
gt; gt; But it only shows 1000 unique entries in that dropdown list. You can still use
gt; gt; Custom and do a bit of typing to see what you want.
gt; gt;
gt; gt; Debra Dalgleish offers some other work-arounds at:
gt; gt; contextures.com/xlautofilter02.html#Limits
gt; gt;
gt; gt; Raj Mazumdar wrote:
gt; gt; gt;
gt; gt; gt; Hi there... have a concept question... What is it meant when it is said that
gt; gt; gt; the Auto-filter works for only the top 1000 entries? Does it mean:
gt; gt; gt; a) The auto-filter works in only the top 1000 rows of records. So if I have
gt; gt; gt; a record that doesn't occur in the top 1000 but occurs in the 1500th row say,
gt; gt; gt; then that record won't be shown on the drop-down auto-filter.
gt; gt; gt; ...OR...
gt; gt; gt; b) The autofilter shows only the top 1000 rows when there is an occurence of
gt; gt; gt; a particular record in more than 1000 rows.
gt; gt; gt;
gt; gt; gt; Please clarify... thanks
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson