So I have two things that I just can't quite figure out.
I have an excel sheet to keep track of customer calls for work and am having a hell of a time doing a formula for are results. So for keeping track of the "Principle $" field I'm using this formula. This one works but I was wondering if their was a way to simplify this further. This biggest complication is that fact that only the latest person to contact the customer gets credit for the calls.
Formula:Please Login or Register to view this content.
Second thing is I can not for the life of me figure out how to calculate the Recovered calls. As these ones as well only go to the latest person but aren't nice enough to be based on amounts and are just based on names if that makes sense.
I know I could probably do this a LOT easier with VBA but the powers that be don't want it to include VBA.
EDIT: Forgot to include pictures.
oPeNyo0.png
BRyn98Q.png
mmAlfzk.png
Bookmarks