ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Removing zero value lines (https://www.excelbanter.com/excel-worksheet-functions/147459-removing-zero-value-lines.html)

ccswfl

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?


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com