This one is a bit tricky.
I've attached a sheet with the preferred outcome in Column AA with some examples.
In essence I require a formula in Cell AA that will look left From C to X, not include the 2 highest figures but give me the sum total of what is left.
Obvioulsy if I can have a one horizontal look/criteria it would be brilliant. Sample data is on 28 clients, actual is in the thousands.
Not sure if it is possible, but I have to ask.
thanks, if anyone can help me....
Bookmarks