Find Best Customer

Originally Posted by stanleydgromjr

mshtuhin,

Detach/open workbook mshtuhin - EF 738765 - SDG14.xls and run macro FindMaxCustomer.

Why to use macro when this can be done with simple formula
Just put this formula in E2

=MAX(M32:M36)

And this one in D2

=INDEX(L32:L36,MATCH(E2,M32:M36,0))

And you'll get the same result which is much easier to understand...