auto filter not working
 

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

auto filter not working
 

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

On Wed, 22 Aug 2007 14:58:01 -0700, Katie
wrote:

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

auto filter not working
 

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
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Maybe your 0 is text and not a real 0

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

On Wed, 22 Aug 2007 14:58:01 -0700, Katie

wrote:

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