Tables

  • Thread starter Thread starter fastcar
  • Start date Start date
F

fastcar

Hi I need some help please,

I have a table as below

Date....................Max Temp.....Min Temp........Ma
Wind........Max Rain
Thu-01-Jan-04..........16.7.............1.8.................10.0...............0.00
Fri-02-Jan-04............14.6..............4.8................35.0...............0.00
Sat-03-Jan-04..........16.9..............3.3................28.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 exce
paste the date that temp was recorded in another cell. ie Look dow
"Max Temp" find "17.1" (as that is the highest temp at the moment) an
the put the date that corresponds to "17.1" which is "Mon-05-Jan-04" i
cell N32.

Hope this is enough information
 
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
 
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)),B5:B10,0),0)
 
Back
Top