LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Using Macros To Perform Multiple Averages

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
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
How to perform lookups based on multiple criteria? Brandon[_3_] Excel Worksheet Functions 4 October 19th 08 06:44 PM
How do I perform multiple formating within a single line of text? TroyG Excel Worksheet Functions 2 October 13th 06 04:27 AM
Using a formula to perform multiple functions. elusiverunner Excel Discussion (Misc queries) 3 October 1st 06 11:31 PM
How do I perform multiple regression in Excel using two independe Freda Excel Worksheet Functions 2 November 29th 05 04:59 PM
Best technique to perform multiple calculations ? [email protected] Excel Worksheet Functions 5 January 25th 05 03:49 AM


All times are GMT +1. The time now is 11:55 PM.

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

About Us

"It's about Microsoft Excel"