used the following to solve my question,
reminded of
KISS ( keep it simple St....)


=VLOOKUP(MAX(B1:B30),C1:C30,1)
thanks


--
userofexcel
------------------------------------------------------------------------
userofexcel's Profile: http://www.excelforum.com/member.php...o&userid=37040
View this thread: http://www.excelforum.com/showthread...hreadid=567691