Hi,

Is there a way (I would assume recursively) to pick sums (or individual numbers) out of a worksheet and compare them to all other sums in a worksheet, then output those results?

We have some reconciliation worksheets we must maintain and reconcile on a monthly basis. There are several clearing accounts which have a typically high volume of transactions. These are exported into Excel from SAP and we then have to hand match individual numbers to sums, sums to numbers, and sums to sums to determine which credits clear out debits and vice versa. So, the amounts in comparison always sum to zero if they clear one another. Hope that makes sense.

I have an idea that I could come up with something on this but it looks to be very time consuming. Has anyone invented (or heard of the invention) of this particular wheel?

Any help is greatly appreciated.