Forum Discussion
Removing positive and negative values in excel
Hello. I am currently dealing with an excel sheet where there is multiple vendors for which each contain innumerable positive and negative value transactions. I would like a formula/shortcut tha...
Thomas610 I believe your need is to match e.g. individual vendor invoice amounts (credits) with individual payments made (debits) to these individual vendor invoices. The attached workbook contains an example for such a situation. It's inspired by this (rather old) article, but it still does the job:
https://www.myonlinetraininghub.com/excel-bank-reconciliation-formula
I have adapted it a little so that it matches amounts by vendor.