Auto Filter Question

Emily

Active Member
Joined
Aug 28, 2002
Messages
304
How to view more than 1000 records in auto filter? Is it a limitation that 1000 records can be scrolled?

Thanks
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Corticus

Well-known Member
Joined
Apr 30, 2002
Messages
1,579
I have this problem too,

The filter "works" for more than 1,000 records, but the drop combos are only populated by the first 1,000 or so unique values.

Try using the advanced filter, and have the criteria range be all of the fields that were part of the autofilter, but located elsewhere.

If you want to get fancy, you could you the advanced filter to make lists of unique values from the records, and the have drop combos where the feild headings for the data set are be populated from these unique value lists.

Then have the drop combos linked to your criteria range for a "main" advanced-filter on the main data-set.

HTH,<EMBED width="110" height="61" src="http://www.liquid2k.com/dacypha/sig2/Corticus.swf"></EMBED>
This message was edited by Corticus on 2002-10-08 12:45
 

Forum statistics

Threads
1,143,613
Messages
5,719,710
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top