Problem with auto filter

neilb

Board Regular
Joined
Apr 18, 2002
Messages
128
HI

I never come across this before.

I have a spreadsheet with 27000 rows. In column B there are a mix of about 500 different account numbers. When I put on the auto filter on it did not pick up every different account number.

Has Auto filter got a max limit to the number of lines it can show??

Neil
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
Yes, there is a limit, but I'm not sure how many rows makes the limit. You could find it by listing numbers down an entire column and then see where auto filter stops.
 

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053

ADVERTISEMENT

Using Philly Girl's suggestion, I came up with 1000. How did you get more?
 

Jay Petrulis

MrExcel MVP
Joined
Mar 17, 2002
Messages
2,040
Hi,

The drop down list in the AutoFilter will show a maximum of 1000 items. You can still use the Custom feature to work with the whole list. Also, the Advanced filter is another way to go, although it may require that your data setup be changed a bit.
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
AutoFilter's drop-down list displays the first 1000 unique entries.
 

Forum statistics

Threads
1,143,704
Messages
5,720,378
Members
422,281
Latest member
jantoooh

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