Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Values With more than 2 decimal Places | Excel Discussion (Misc queries) | |||
Finding unique values with Criterias | Excel Discussion (Misc queries) | |||
Finding Unique Values in Column | Excel Discussion (Misc queries) | |||
Finding Values in a "Matrix" | Excel Discussion (Misc queries) | |||
Finding the max of a column where values less than a specified number | Excel Worksheet Functions |