Why is autofilter only filtering up to # of rows in prev column?

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

When I select '#NA', for example, in one of my columns, it only pulls the
#NA's up to the last row in the previous column and then leaves the rest of
its own column unfiltered.
 
My bet is that you let excel guess at the range that should be filtered and it
guessed wrong.

Empty rows or empty columns can confuse excel.

Try removing the autofilter
Then select the entire range to filter
and reapply the filter

Then test once more.
 

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

Counting strings of consecutive numbers in a column 1
Autofilter expert needed. 8
Trouble identifying filtered column 1
autofilter question 3
Problem with filtering columns in Excel 2007 1
Auto-filter selection 1
Autofilter to filter out non-numeric rows 3
Date subtraction 1

Back
Top