Auto Filter not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I have a column of data with different function codes in it. I am trying
to use Auto Filter to pick out all instances of 1 function code, but when I
use the Auto filter function, it doesn't work. It will give me one desired
result at the top of the sheet then the rest is not filtered at all. Any
ideas?
 
One guess hazarded ... Try using "contains" / "does not contain" within the
Custom Autofilter dialog.
 
Perhaps there's a blank row somewhere in the table, that's blocking the
bottom rows from being included.

Remove the AutoFilter (Data>Filter>AutoFilter)
Then select the entire table, and reapply the filter
 

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

Auto filter hidden cells 1
Auto fill not working 2
How do I protect a range but allow auto filtering in earlier versi 1
filter not working 2
Auto Filter 3
Auto Filter 2
Macro to allow auto filter after running password protect 1
Data - Filter - Auto Filter 1

Back
Top