hi. I have a spreadsheet with names, ID#s for those names, and direct
deposit info. For each person, they have multiple rows. One column
indicates A or B, which tells if the amount going into an account is a part
of the whole, or the balance. Another column indicates the priority of said
amount.

In order for payroll to run correctly, all "B" amounts MUST have a greater
priority number than all "A" accounts, as when it runs, if it first sees a B
amount, it just takes the whole balance, sweeps it into the account, and
doesn't leave anything for any of the "A"s

I'm at a loss for how to return the values of people with B balances with a
priority lower than their A balances. Any ideas in Excel or Access?