Puttign your data starting in cell a4 ("date")
=OFFSET(A4,MATCH(MAX(B5:B10),B5:B10,0),0)
If you want to be able to id the max in a given month more is needed
--
duane
------------------------------------------------------------------------
duane's Profile:
http://www.excelforum.com/member.php...o&userid=11624
View this thread:
http://www.excelforum.com/showthread...hreadid=278137