Autofilter not grabbing last row

E

Elaine

When I autofilter a criteria, it also includes the last row of data, which
shouldn't be included as it doesn't meet the criteria. For example, to
autofilter by 00001 (knowing there are 5 records with 00001), I get the
following:

00001
00001
00001
00001
00001
00099

Why is it pulling 00099? I've tried to remove autofilter and apply it
again. I've even tried copying the data to a new worksheet. Doesn't work.
 
F

Fred Smith

Your title says "not grabbing last row", and your description says the last
row is included in error. Which one is it?

Is the row number with the 00099 in it displayed in blue? If not that's your
problem -- the row is not being included in the Autofilter. Either redesign
your spreadsheet, or select the rows you want filtered first, then apply
autofilter.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top