how to suppress accounts with zero balance

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.

Preparation

Accepted answers

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

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

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

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!