ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Summary of Max Hourly entries (https://www.excelbanter.com/excel-worksheet-functions/32238-summary-max-hourly-entries.html)

Al

Summary of Max Hourly entries
 
Hello
My data sheet is laid out as follows with hourly readings:

Date Hour Temp RelHum WindSpeed

On my summary sheet, for the date of the monthly high temp, I would like to
have:

Date Hour Temp RelHum WindSpeed

What formula would I use to accomplish this?

Thanks!



All times are GMT +1. The time now is 08:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com