Is there a limit to the number of lines autofilter can show?

[hants_ittu]

Help!

We are using autofilter in Excel and we are finding that it is not filtering information we know is present in our long list (over 1350 lines).

Is there a maximum number of lines that can be filtered?

Thank you!

 

[dk]

Re: Is there a limit to the number of lines autofilter can s

The maximum is 1000 different items. See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q295971

 

[Richie(UK)]

Re: Is there a limit to the number of lines autofilter can s

Hi,

I believe that there is a limit of 1,000 unique items (prior to Excel97 the limit was lower than this).

HTH

EDIT: DK - TDQ! :wink:

 

[hants_ittu]

Re: Is there a limit to the number of lines autofilter can s

Many thanks for such a quick response. Brilliant.

 

[Mark W.]

Re: Is there a limit to the number of lines autofilter can s

Help!
...Is there a maximum number of lines that can be filtered?

Thank you!

The only limit on the number of lines that can be filtered is the physical limit of 65,535 (allowing for 1 row of column headers). The 1,000 unique item limit mentioned above only pertains to the number of entries that can be displayed in the AutoFilter drop drown list. The absence of an entry in the drop down list doesn't prevent you from using the Custom drop down list entry and specifying an AutoFilter criteria.