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/