A
Atholl Fitzgerald
Can anyone tell me the maximum number of rows that can be filtered?
Thanks in anticipation.
Thanks in anticipation.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
see your post in public.excel
P.S.: plaese don't multipost
see your post in public.excel
P.S.: plaese don't multipost
D
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
'=================================================
'=======================================
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
'=================================================
P
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 **
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 **
D
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.
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.