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
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