2 Tiered Commisions Formula

if you had a list of account and they didnt change you wouldnt need the helper

the helper columns counts how many times an account code is used as a running total. if it is the firs time its used then i shows what row this happens

then using the index and small you can pull in the account numbers used.

these are then used in the calculations i provided earlier.

i know some this is unclear but over time you should be able to figure it out.

i wont be on until tomorrow i think so i wont be able to help you further but im glad i got you as far as i did.

if you need more assistance ill gladly help you out tomorrow.

regards

Twiggy

Ps the top table didnt have the ranges adjusted so it wont pick up all the information (they still show $50) that might clear that up for you

if all that answers your thread remember to mark it solved and a star tap to anyone that helps is always appreciated