I far as I knew the autofilter list (i.e. the list that is shown) only shows
the first 1000 entries BUT the custom filter will search the entire range,
i.e. Up to 64,000 or so records/rows.

"JE McGimpsey" wrote:

An autofilter list can only display the first 1000 items. See

http://contextures.com/xlautofilter02.html


In article ,
"Kschu" wrote:

Does the autofilter feature have a limit to how much it can search? I have a
jobfile list over 2500 entries and only seems to serach about half of them.

It there a setting to increase this search capablity if there is a default
limit or a workaround?