Maximum in a Range by Customer Identifier

Hello all,

I'm a little stumped on a problem I am working with and hoping someone can help. It's essentially a simple VLOOKUP procedure but looking for the maximum match as opposed to the first available match. I've attached a sample spreadsheet because I'm sure I didn't describe it very well.

Looking for a formula if possible - not VBA or the use of a pivot table.

Thanks!
Scott

If you do not want an array formula, there is the other option of database functions, but they are rather cumbersome. They require additional space to define constraints.

Attached is the same spreadsheet calculating the maximums using database functions.