Hi:

I create sets of financials for multiple entities in Excel based on a
standard template. Not all of the accounts are used in each entity. This
causes a line with a description and a zero to be returned. I need to find a
way to get rid of the lines with zero values and also, not leave a blank line
in its place. Is there a formula that can be used to do this?

Thanks!