Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with macros for getting daily averages from 10 minute increment data - MS2000
Jen,
Use a pivot table - select all your data, then use Data | Pivot Table... Drag the date to the row field, and the data value to the data field. Use either SUM or AVERAGE for the field setting, depending on whether your desired average is the average of the 10 minute values or the sum of the 10 minute values. HTH, Bernie MS Excel MVP "feoj" wrote in message ... hi - i am spending endless hours of cutting, copying, pasting and averaging in excel and am hoping someone can help me with a macros. i am using microsoft excel millenium edition. i have many worksheets of stream flow data. this data is set up with a date in one cell, the next cell notes the 10 minute increment, and the next cell the average streamflow for that 10 minute increment of the day. there are many entries for the same date because it is in 10 minute increments. what i need is a daily average for each day. ex: of data set up 10/2/03 00:10 .25 10/2/03 00:20 .34 10/2/03 00:30 .76 etc., for a whole year, and i need daily averages any help is GREATLY appreciated!! jen ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Computing Averages For Daily Sales | Excel Discussion (Misc queries) | |||
Daily Averages | Excel Discussion (Misc queries) | |||
automatically increment y-axis daily | Charts and Charting in Excel | |||
Excel Formula to Calc Daily Averages? | Excel Worksheet Functions | |||
help with macros for getting daily averages from 10 minute increment data - MS2000 | Excel Programming |