# Consecutive average in column into Microsoft Excel

1. ## Consecutive average in column into Microsoft Excel

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

2. ## Re: Consecutive average in column into Microsoft Excel

How many rows are there?

this is a volatile function( if there are too many of this formula it will slow down excel computation)

say cell A1=AVERAGE(OFFSET(INDIRECT("K"&ROW(K1)*100-99),,,100)) drag down

3. ## Re: Consecutive average in column into Microsoft Excel

I have 36000 data in one column. Your formula =AVERAGE(OFFSET(INDIRECT("K"&ROW(K1)*100-99),,,100)) is working properly. Thank you so much. I am really very happy. Last time I have spent a lots of time to do it manually. Really you are very helpful. Can I get your email ID please. My email address:

Thanks
With Regards
Taposh Roy

Note: I have to delete your e-mail otherwise you'll be receiving spams. Vladimir

4. ## Re: Consecutive average in column into Microsoft Excel

Your welcome. Nice to hear that.

Regards,

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1