Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Al
 
Posts: n/a
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking References from Multiple Sheets to One Summary Sheet Kim Setting up and Configuration of Excel 3 May 5th 05 04:56 PM
Merge, update, and add only new entries into a list from other she Chab Excel Worksheet Functions 1 May 1st 05 11:05 PM
How do I change multi-line entries to single line entries in Exce. CPOWEREQUIP Excel Worksheet Functions 3 April 14th 05 12:38 AM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 08:13 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM


All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"