Lookups

[Carl]

I have two columns, the first is a month of date/time entries in 15
minute increments, the second is a value. I want to list the maximun
"value" for each 6 hour
(00:01-06:00,06:01-12:00,12:01-18:00,18:01-23:00) period, such that
there are only 4 entries per date.

I am sure there is an easy "function" that can do this.


Thanks

 

[zvkmpw]

I have two columns, the first is a month of date/time entries in 15

minute increments, the second is a value. I want to list the maximun
"value" for each 6 hour
(00:01-06:00,06:01-12:00,12:01-18:00,18:01-23:00) period, such that
there are only 4 entries per date.

If the original data is in chronological order starting at a six-hour
boundary, then the first column need not enter into the calculation.

Each value in the new list comes from 24 consecutive "values."

If the values start at B1, then try putting this in C1 and copy down:
=MAX(OFFSET($B$1,24*(ROW()-1),0,24,1))