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...
To average blocks of 24 entries you could use
= BYROW(WRAPROWS(data, 24), AVERAGEλ)where
AVERAGEλ
= LAMBDA(x, AVERAGE(x))