Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The pivot tables 101 article says to use the "Create List" comman. | New Users to Excel | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
How to change default page setup for pivot tables? | Excel Discussion (Misc queries) | |||
Quaters In Pivot Tables | New Users to Excel | |||
How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) |