Forum Discussion
Solved
I have a huge data to calculate its average 59 values in one cell then 59 values next to previous
I wanted a formula to complete my work I got a data which is huge in row but i just wanted its first 59 values average then that rows second 59 values average and soo on utill data ended he...
See the attached version. It uses the formula that I proposed.
It seems you want to average the values for each hour. But why do you average 59 values instead of 60?
The easiest way for averaging values per hour is a pivot table.