I have a master database that I build by pasting smaller databases into it
and now contains over 4,000+ rows. Every so often I'd like to check if there
are empty rows included by filtering and selecting the "(Blanks)" option at
the bottom of the pull-down filter menu on the specific column. I'm just
surprised that when my data exceeds 2,700+ the options (Blanks) and
(Non-blanks) are no longer displayed at the bottom of the pull-down menu even
if the (Blanks) and (Non-Blanks) option appear on the other columns'
pull-down list. Although I could use the customize option, I'm beginning to
think that there might be a problem with the file. In addition, sometimes
data at the bottom of the database don't appear in the pull-down menu.
Please help and hope someone can explain why this happens so I can prevent
this in the future.
Thanks!!!