Tables

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
 
D

duane

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
 
D

duane

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top