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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"doublew" wrote:
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?

Perhaps there's a blank row somewhere in the table, that's blocking the
bottom rows from being included.

Remove the AutoFilter (DataFilterAutoFilter)
Then select the entire table, and reapply the filter

doublew wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html