Advanced Filters - can I "not"
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
|