View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WendyMc WendyMc is offline
external usenet poster
 
Posts: 7
Default 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