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.
In N4
=AVERAGE( INDEX($E$4:$E$100000, (J4-1)*59+1):INDEX($E$4:$E$100000, J4*59) )and drag it down
where to put this code ?
- its giving error