+ Reply to Thread
Results 1 to 4 of 4

Consecutive average in column into Microsoft Excel

  1. #1
    Registered User
    Join Date
    09-12-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2013
    Posts
    8

    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. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    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
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    09-12-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: Consecutive average in column into Microsoft Excel

    Hi Vlady,
    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
    Last edited by vlady; 09-12-2013 at 03:53 AM.

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Consecutive average in column into Microsoft Excel

    Your welcome. Nice to hear that.
    Another one is you can mark your thread "Solved" Please look below my signature for instruction.

    Regards,
    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding Average two consecutive rows in a column
    By windme in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-28-2013, 11:53 AM
  2. [SOLVED] Average for non-consecutive cells, excluding zero values.
    By musik7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2013, 06:11 PM
  3. Replies: 6
    Last Post: 03-23-2012, 06:03 PM
  4. Microsoft Excel-locking a column
    By Bonnie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-25-2006, 10:50 AM
  5. [SOLVED] Average, Excluding Zeros, Non-Consecutive Range
    By Coal Miner in forum Excel General
    Replies: 9
    Last Post: 08-04-2005, 06:05 PM

Bookmarks

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