Missing Filtered Data

[Trisya247]

Hallo my friend,

Do anybody out there know why when i filter my data, the result is incomplete?

Let say I have a huge data, 50 width x 300,000 column. When I filtering one
column, example birth date or amount paid - some data is missing. In actual
data it exist but when filtering, it missing.

Could it happen because of Excel cannot calculate when the data/listing is
exceed his limit or something else?

 

[David Biddulph]

If you mean that in the autofilter drop-down list you are not seeing all the
different values, see this advice:
http://www.contextures.com/xlautofilter02.html#Limits

 

[Max]

Another interp/possibility is the manner in which you apply the autofilter,
especially where data may have in-between blank row breaks not immediately
apparent. Try removing the autofilter, then select the entire sheet (or
entire range, including the header row), then re-apply autofilter. Joy? wave
it, hit the YES below