autofilter question

[jim]

hi...

I have a spreadsheet with about a dozen columns and a couple thousand
rows. No empty rows or columns. When I attempt to use autofilter on
one of the columns, it only displays about two thirds of the data that
I know is there. Can anyone offer any suggestions as to why this might
occur?

TIA

Jim

 

[Dave Peterson]

If you're using xl2003 or below, then the list under the dropdown arrow is
limited to 1000 unique entries.

So that could be the trouble.

(If you're using xl2007+, then that limit is 10,000 (if I recall correctly).)

But another problem could be that you let excel guess at the range to filter.
If your data contains any empty rows, then excel will see this as a delimiter
and not include those rows under that first empty row.

If this is the case, you should remove the filter and then select the entire
range that should be filtered -- then reapply the filter.

 

[jim]

If you're using xl2003 or below, then the list under the dropdown arrow is
limited to 1000 unique entries.

So that could be the trouble.

(If you're using xl2007+, then that limit is 10,000 (if I recall correctly).)

But another problem could be that you let excel guess at the range to filter.
If your data contains any empty rows, then excel will see this as a delimiter
and not include those rows under that first empty row.

If this is the case, you should remove the filter and then select the entire
range that should be filtered -- then reapply the filter.

Thank you, Dave - it was indeed the 2003 version. I didn't know about
that limitation.

 

[Dave Peterson]

Debra Dalgleish shares some workarounds:
http://contextures.com/xlautofilter02.html#Limits