filter problem

[Fion]

Dear friends,

I'm having problem in filter function. I've a excel file with 2466 rows in one sheet. After I've apply AutoFilter, why I cannot see all the data that I have from the filter list?

Best regards,
Fion

 

[John Wilson]

Fion,

I assume that you're talking about the "Drop Down" for the AutoFilter.
1,000 is the limit for "displayed" choices in the AutoFilter.

For more on this and some 'workarounds", take a look here:

http://www.contextures.com/xlautofilter02.html#Limits

John

Dear friends,

I'm having problem in filter function. I've a excel file with 2466 rows in

one sheet. After I've apply AutoFilter, why I cannot see all the data that
I have from the filter list?