Does anyone know is there an "easy" formula to find and match transactions and calculate diff?
Example;
I have 4 rows: two rows for invoice number and one row for invoice amount and one for transaction. I would like to match the invoice numbers and calculate the diff. It should be 0.
A B C D
3180 3180 51150€ -51150€ = 0
Ideas?
Bookmarks