View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ccswfl ccswfl is offline
external usenet poster
 
Posts: 2
Default Removing zero value lines

I have a spreadsheet that has lines with zero values. It's a financial
statement based on a template that includes every possible account, but some
accounts are not used for some entities. Zero values are returned for those
lines. I am trying to remove those lines and have the financial only print
with the lines having data. Is there a formula that I can use that would
remove those lines?