auto filter not working

K

Katie

I have my auto filter on to keep anything that does not equal 0...it is
working well except that it keeps the last line in my project which is 0.

Does anyone have a fix for this?

Thanks!
Katie
 
G

Gord Dibben

Maybe your 0 is text and not a real 0

Delete it, format the cell to General and re-enter the 0


Gord Dibben MS Excel MVP
 
D

David Biddulph

Or perhaps it is a very small number, which your formatting showed as zero.
Set the cell format to General & see what it displays, also what does the
format bar show? Does =(cell_ref=0) show TRUE or FALSE? If you've got
small numbers resulting from fixed point calculations you may wish to test
for something like:
ABS(cell_ref)<10^-8 (adjust tolerance to suit your data), rather than for
cell_ref=0
 
Top