All I need to do is compare debit and credit columns from client TB to debit and credit columns from our AP software to generate columns 5 and 6 which are the adjustments for the client - you know the sort of thing.
Having got on my high horse recently and told our team off for using Excel as a WP tool instead of using formulae, I find that I'm struggling with this one! I suspect nested functions are involved, but my brain is too small to cope. The problem is that a debit could arise from an increasing debit, a decreasing credit or a credit becoming a debit!
Can anyone help?