Forum Discussion
FORMULA TO OFFSET NEGATIVE AND POSITVE NUMBERS
Good morning I am looking for a formula where I can offset a worksheet with positive and negative numbers without manually finding the opposite number. For example if I have 100 I want to be abl...
I thought about a pivot table but it won't work for what I need. I will try to give a better example. I am trying to offset a balance sheet and need a formula so that I am not going line by line to find the offsetting transaction.
Tonya1205 Perhaps the attached file contains something you could use. It a small example I picked up a long time ago on myonlinetraininghub. Originally meant for bank reconciliations, you can use the same technique for for matching debits and credits in any transaction list. The helper column B in the table holds the formula that finds offsetting amounts.