Hi All,

Is there an add-in or a way of allowing Auto Filter to look beyond
1,124 rows?

Thanks for your help

Tom Snyder


x-- 100 Proof News - http://www.100ProofNews.com
x-- 30+ Days Binary Retention with High Completion
x-- Access to over 1.9 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

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.

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. Also,
there are a couple of workarounds he

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


lehigh46 wrote:
Is there an add-in or a way of allowing Auto Filter to look beyond
1,124 rows?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html