I can say one thing logically it will work..
First put one formula on speate column can count only the value > 0 , O ,P like [ =countif(range,">0") ] then put filter on that so wen filter is on you can always see not equal zero .. You can put filter filtering above zero by using macro just record one macro and do one time filter then stop macro so you can do that automatically ...
Best of luck
Bookmarks