Tables
 

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

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

this (entered as cntl-shift-enter) allows you to get the date of the max
in a specified month (the =1 indicated Jan)

=OFFSET(A4,MATCH(IF(MONTH(A5:A10)=1,MAX(B5:B10)),B 5:B10,0),0)


--
duane


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