Custom option when using Autofilter

rstone25 · Mar 14th, 2002, 07:17 AM

Hi,

Is there a limitation on how many lines can be displayed when you click on Custom in the Autofilter?

I am not getting all the data thats in the spreadsheet in the drop down list.

There are just under 3000 lines in the document.

Thanks

Mark W. · Mar 14th, 2002, 07:54 AM

The limit is 1,000 unique values. You can use Advanced AutoFilter with a criteria range to work around this limit.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 07:17 AM	#1
rstone25 New Member Join Date: Feb 2002 Posts: 14	Hi, Is there a limitation on how many lines can be displayed when you click on Custom in the Autofilter? I am not getting all the data thats in the spreadsheet in the drop down list. There are just under 3000 lines in the document. Thanks

Mar 14th, 2002, 07:54 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	The limit is 1,000 unique values. You can use Advanced AutoFilter with a criteria range to work around this limit.