I can't reproduce your problem. Perhaps you could indicate it by
describing more fully what happens: i.e., the range to be filltered,
where the blanks are, where the unwanted data is, what you select, where
you add a new entry. You don't need to use the whole range if it's too
large; just enough to illustrate the problem.

Alan Beban

Shereene wrote:
Hi:

I also realise that when I apply the autofilter to the data, I do not get
the (blanks), (nonblanks) option from the drop-down list. Also if I add a new
entry that has not been in the list before, it does not show up in the
drop-down.
Shereene

"bj" wrote:


Was the odd item in the range that was filtered?
if not, you may need to change your method for range selection (I have been
burnt by this)

"Shereene" wrote:


Can someone please help me with this problem I have with Excel autofilter.

I applied an autofilter to a list of data that does not exceed the 1000
items limit, and attempted to filter the data to get a particular item. The
filter did bring up all the items needed, but it also had at the bottom of
the filtered list, another item that was not part of the items to be
filtered, which unfortunately affected my subtotal calculation. Can some one
please advise.

Thanks so much