filter problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

Fion said:
Dear friends,

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