Forum Discussion
Help for Excel
Hey everyone Mabey someone can help me. I' ve been searching for a formula on Excel, that counts the average of 24 lines in a tabel with some tausends of data points. Selecting manualy 24 Lines e...
Depends on which Excel platform/version you and do you mean running average or average of each 24 lines block.
As variant
=LET(
r, ROWS(data),
n, UNIQUE( INT( (SEQUENCE(r)-1)/24)),
MAP( n, LAMBDA(i, AVERAGE( INDEX(data,
SEQUENCE( MIN(r-i*24, 24),,i*24+1) ))
) ) )