LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Blanks and Advanced Filters Janie Excel Discussion (Misc queries) 7 August 24th 06 06:31 PM
Microsoft Excel 2003 - Advanced Filters Kel Excel Worksheet Functions 1 February 17th 06 02:10 PM
How do I use advanced filters in excel? Jessica Excel Discussion (Misc queries) 1 February 5th 06 11:56 PM
Advanced Filters Louise Excel Worksheet Functions 9 October 28th 05 11:52 AM
Advanced Filters Louise Excel Worksheet Functions 3 September 26th 05 11:57 AM


All times are GMT +1. The time now is 03:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"