how to suppress accounts with zero balance

[Taxguy03]

Hello experts, we have a two years comparable trial balance (two columns for each of the two years). 

Is there a tool to exclude/suppress "zero balance accounts" for an account (only if zero's in both years)?

We wanted to cut down the size of the file (it's close to 70K rows).

A sample workflow idea would be appreciated. 

Please see a sample excel file.

Thanks again for your help. 

[danilang · Accepted solution]

Hi @Taxguy03 

The easiest way to do this is to use a Filter tool with a formula similar to 

[2020 Ending] != 0 and [2019 Ending] !=0

Dan 

[Taxguy03]

Thanks, Dan. Worked like a magic. Take care. 

[ang2816]

Hi there! I tried this filter tool on a similar issue, but my false anchor is still pulling through columns that have amounts in them.

Is there anything I can do to have those accounts pull into the true anchor?

Thanks all!