I'm trying to set up a worksheet to do a very tedious task for me. The first chunk I've got figured out, but the second is proving tricky.
I'm trying to populate a list of accounts that have effectively over-drafted. I have one worksheet that updates weekly that includes all accounts and their current balances. Another worksheet includes up to two numbers per account: priority charges and general charges. Not every account will have been charged that week.
I'd like to setup a third sheet so that it'll tell me which accounts are over-drafted, but it would ideally check against both priority charges and total charges. If an account has enough money to cover Priority charges, it'll then check