Auto Filter not working

D

doublew

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

Max

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

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
 
Top