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!