Misc 04)

Look For Up to 25 Offsetting Balances

This is a dream tool for accountants needing help with account reconciliations.

It helps you find multiple items that zero each other out. Because of the overhead involved it will only handle up to twenty five values at one time. In most cases you can narrow your offsetting lines by making use of the ABS and SUMIF functions, then resort to this handy feature for those items which don’t have a direct offset.

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc