hi all,

Ive managed to create a table that shows me a summary of bank account balances (one list being positive, one being negative) to demonstrate money owned and money owed.

What im struggling with is creating a formula to compare the account values to provide a result that will identify which 'money owned' should pay off which 'money owed'. [interest rate on money owed not applicable]

crudely, I have column 'a' with a list of accounts with money owned, column 'b' with accounts of money owed.

Any help is much appreciated!

Thanks, Rob