Hello,
I have a lots of data in one column. I want to average my data at the regular interval, like averaging first 100 data then averaging next 100 data and consecutively like this. I have used =AVERAGE(K1:K100) to get first 100 data then want =AVERAGE(K101:K200). But if I copy to next cell bellow normally in excel it comes =AVERAGE(K2:K101). Is there any way to solve this? Thanks in advance.

With Regards
Taposh Roy
Malaysia