Hi I need some help please,

I have a table as below

Date....................Max Temp.....Min Temp........Max
Wind........Max Rain
Thu-01-Jan-04..........16.7.............1.8.................1 0.0...............0.00
Fri-02-Jan-04............14.6..............4.8............... .35.0...............0.00
Sat-03-Jan-04..........16.9..............3.3................2 8.0................0.00
Sun-04-Jan-04..........14.7.............1.5................26 .0................0.00
Mon-05-Jan-04.........17.1..............1.9...............18. 0................0.00
Tue-06-Jan-04..........13.5..............3.2................8 .0.................0.00

I would like excel to find the max temp for the month and have excel
paste the date that temp was recorded in another cell. ie Look down
"Max Temp" find "17.1" (as that is the highest temp at the moment) and
the put the date that corresponds to "17.1" which is "Mon-05-Jan-04" in
cell N32.

Hope this is enough information.


--
fastcar
------------------------------------------------------------------------
fastcar's Profile: http://www.excelforum.com/member.php...o&userid=16457
View this thread: http://www.excelforum.com/showthread...hreadid=278137