Perhaps something like this is the adjacent column

=LOOKUP(MAXA(B1:B10),B1:B10,A1:A10)


--
patrickcairns
------------------------------------------------------------------------
patrickcairns's Profile: http://www.excelforum.com/member.php...o&userid=31790
View this thread: http://www.excelforum.com/showthread...hreadid=515615