find the max among a range of cells and repeat the search 365 times

[AmandaSS]

Hallo,

I have 8760 rows and one column with one value for each row.

row1	10
row2	23
row3	4
...
row 24	50
....	....
row8760	39

<tbody>
</tbody>

I need to check every 24 rows what is the max value, up to the 8760th row (in 8760 rows I have to find 365 max values=8760/24). I.e. the max value in the first 24 rows, the max value in the second 24 rows, the max value in the 3rd 24 rows, and so on.
Can someone help?

Thanks
Amanda

 

[barry houdini]

Please continue in your original thread here