Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In my Excel file i have over 1000 rows of data. This contains temperatures
measured each minute for each hour for each day over a month. Yes i know that's a lot of data! I want to be able to get an average hourly temperature for each hour of the day as a way to simplify my spreadsheet. So basically what i want to do is average the temperatures recorded between 9:00am and 9:59am for 9/3/2009, and do the same thing for each hour of that day as well as every other day. Is there a macro or something i can use to speed things up? I have tried doing it the long way and it is of course pain-stakingly slow - in which case i thought to myself there must be an easier and quicker way to do this! Can anyone be able to help me? Thanks, --Max |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to perform lookups based on multiple criteria? | Excel Worksheet Functions | |||
How do I perform multiple formating within a single line of text? | Excel Worksheet Functions | |||
Using a formula to perform multiple functions. | Excel Discussion (Misc queries) | |||
How do I perform multiple regression in Excel using two independe | Excel Worksheet Functions | |||
Best technique to perform multiple calculations ? | Excel Worksheet Functions |