Consolication of data

[mluetkem]

Anyone have a quick way of taking a set of data (x value of time) tha
is presented in 10-minute bins (data point every 10-minutes) an
consolidate to 30-minute binned data sets (essentially sum every
10-minute bins to each 30-minute bin).

Thanks.

Mik

 

[mluetkem]

My data actually starts in B9, does that changes how things are done i
the formula?

Mik

 

[mluetkem]

My data actually starts in B9, does that changes how things are done i
the formula?

Mik

 

[Guest]

Hi Mike
Using the second fromula I provided you can set it up for any starting cell. For B9 the formula will be

=SUM(OFFSET($B$9,(ROW()-9)*3,0,1,1):OFFSET($B$9,(ROW()-9)*3+2,0,1,1)

Enter this on row 9 and then copy down. I made a slight change in the second OFFSET formula. The row offset is now set up to be the same value as the starting cell plus 2

After you have created the new table you can Copy and Paste_Special>Values to convert the formulas into hard numbers

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- mluetkem > wrote: ----

My data actually starts in B9, does that changes how things are done i
the formula

Mik