Forum Discussion
How to run a 24-cell block formula
Good morning, I have a small problem and I wanted to know if anyone can support me. What I need is for my Excel formula to take 24 cells to get an average and to drag it take the next 24 cells, that ...
Assuming your values are in Column A, a shorter non-volatile formula, starting in B1, is:
=AVERAGE(INDEX(A:A,ROW()*24-24+1):
INDEX(A:A,ROW()*24))
=AVERAGE(INDEX(A:A,ROW()*24-24+1):
INDEX(A:A,ROW()*24))