View Single Post
  #1   Report Post  
Al
 
Posts: n/a
Default Finding Max values

Hello
Repost of early question...

My data sheet is laid out as follows with hourly readings:
24/7/365
Date Hour Temp RelHum WindSpeed


On my summary sheet, for each month I would like to find the line with the
max temp and copy the rest of the data from that line

Date Hour Temp RelHum WindSpeed

What formula would I use to accomplish this?

Thanks!