Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with excel macros getting daily averages from 10 minute data
hi-
i am using Microsoft ME Exel, Pentium III, 127 MB RAM. i have many years worth of 10 minute streamflow data and need to compress it into daily averages. the data is set up like this 1/1/03 00:10 .56 1/1/03 00:20 .89 1/1/03 00:30 .91 etc, for a whole year, in three columns any help to save me from endless hours of averaging, cutting, copying and pasting is GREATLY appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with excel macros getting daily averages from 10 minute data
select you data and do Data=Pivot Table report
Make the data/time your row filed and you stream values the data field. If you have xl2000 or later, this is done on the last screen of the wizard by selecting the layout button. When you drag the data field to the data area, double click on it and select average. when the table is created, the right click on the row field and group on day. This should give you your daily average. I assume you date and time are in the same cell. If you have them in separate columns, insert a dummy column and do =A2+B2 in C2 format it as date and time using the custom format, then drag fill down the column. Debra Dalgleish has some information on creating pivot tables at her site. http://www.contextures.com/tiptech.html -- Regards, Tom Ogilvy "jen" wrote in message om... hi- i am using Microsoft ME Exel, Pentium III, 127 MB RAM. i have many years worth of 10 minute streamflow data and need to compress it into daily averages. the data is set up like this 1/1/03 00:10 .56 1/1/03 00:20 .89 1/1/03 00:30 .91 etc, for a whole year, in three columns any help to save me from endless hours of averaging, cutting, copying and pasting is GREATLY appreciated! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with excel macros getting daily averages from 10 minute data
jen
Select the data then DataPivot Table. Follow the Wizard through. Date would go into ROW box. Number and Time(if required) would go into DATA box. Gord Dibben XL2002 On 10 Nov 2003 10:55:50 -0800, (jen) wrote: hi- i am using Microsoft ME Exel, Pentium III, 127 MB RAM. i have many years worth of 10 minute streamflow data and need to compress it into daily averages. the data is set up like this 1/1/03 00:10 .56 1/1/03 00:20 .89 1/1/03 00:30 .91 etc, for a whole year, in three columns any help to save me from endless hours of averaging, cutting, copying and pasting is GREATLY appreciated! |
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) | |||
Excel Formula to Calc Daily Averages? | Excel Worksheet Functions | |||
help with macros for getting daily averages from 10 minute increment data - MS2000 | Excel Programming | |||
help with macros for getting daily averages from 10 minute increment data - MS2000 | Excel Programming |