Auto Filter not working

[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?

 

[Guest]

One guess hazarded ... Try using "contains" / "does not contain" within the
Custom Autofilter dialog.

 

[Debra Dalgleish]

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