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.
Solved! Go to 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
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!
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |