Filter Limitations

[Atholl Fitzgerald]

Can anyone tell me the maximum number of rows that can be filtered?
Thanks in anticipation.

 

[Frank Kabel]

Hi
see your post in public.excel

P.S.: plaese don't multipost

 

[Debra Dalgleish]

As answered in microsoft.public.excel:

'=======================================
An AutoFilter should be able to sort all the rows in the worksheet. If
some rows are being excluded, perhaps there's a blank row somewhere in
your table.

However, an AutoFilter dropdown list will only show 1000 entries. If
your column has more than 1000 unique items, they can be filtered, but
they can't all be displayed in the dropdown list. The items in the
column appear alphabetically sorted in the dropdown list, and only the
first 1000 alphabetical entries will appear.

To AutoFilter for an item that doesn't appear in the dropdown list, you
can choose Custom from the dropdown list, and type the criteria, as
you're currently doing. Also, there are a couple of workarounds here:

http://www.contextures.com/xlautofilter02.html

'=================================================

 

[Paul B]

Autofilter is 1000 entries, have a look here for some work arounds

http://www.contextures.com/xlautofilter02.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[DDM]

Atholl, I suppose the best answer is "whatever your computer can handle."
Some of the limits of AutoFilter are given on this page:
http://www.contextures.com/xlautofilter02.html#Limits. If you search the
topic "Specifications" in Excel's help you'll find the limits for many of
Excel's features, but it doesn't say anything about filters. As an
experiment, I filled every cell on a worksheet with random numbers, then ran
an AutoFilter. It took a while, but it worked.