Hi,

I have a column with the measured temperature every hour of the year(8760
values). I wolud like to convert these to the mean value for each day (365
values).

Does anyone know a simple formula/function for this purpose?

I got this formula from another thread, however I don't know how to change
it so that my first value is calculated on B3 for the values A3:A26

B1: =AVERAGE(OFFSET($A$1,ROW()*24-24,,24))

Does anyone know how I can change this formula so that it can start on the
3rd row??


Many thanks!!