On Oct 11, 6:09*pm, Dave Peterson wrote:
=LOOKUP(2,1/(C1:C99=MAX(C1:C99)),A1:A11)

Cute! Thanks.

Adjust the range to match, but don't use the whole column
(unless you're using xl2007).

By "whole column", I presume you mean a range ending with row 65536.
If not, please elaborate.