Advanced Filters - can I "not"

[WendyMc]

I would be grateful for any help - I have a spreadsheet with 8000 rows, I
would like to be able to hide the rows that contain a 0.00 - and entering the

0 in the advanced filter worked fine - however I would also like to be able

to see the data that is a negative ie -109.00 Is there some way I can enter
Not 0.00 or does not equal 0.00 Does any of this work in advanced filters??
Many thanks for any advice

Wendy

 

[RichardSchollar]

Hi Wendy

Have you tried using a standard Autofilter and using a custom filter
from the dropdown arrow of the relevant column of "Does not equal" 0?

Richard

 

[David Biddulph]

No. Autofilter works happily up to Excel's limit of 65536 rows. There is a
limit as to how many data values Autofilter will show in the drop-down box,
but there are workrounds for that.