+ Reply to Thread
Results 1 to 2 of 2

Average every other nth row

  1. #1
    Registered User
    Join Date
    05-12-2021
    Location
    England
    MS-Off Ver
    2104
    Posts
    1

    Average every other nth row

    Hello everyone,

    I'm looking for a way in which I can take every nth row (B:2,B:33,B64 etc) and come out with a cumulative average.

    I conducted 200 tests, each taking 62 seconds and recording results every 2 seconds. So each test is 31 rows. You can see that the "time-elapsed" (Row A) fields repeat from 2 - 64. I'm trying to take all the data I recorded at 2 seconds and create a cumulative average from it, this would then be repeated for 4, 6, 8, 10 etc seconds until I turn the 6200 rows I have now into 31 rows each representing the 2 second intervals (2,4,6,8,10 etc). I've tried some equations before but they aren't quite what I wanted. I'm wondering if any of you could help me with this?

    Thanks in advance,

    Will

    Edit:

    Kudos to tootall#6875 on the Microsoft-community discord server for this answer

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by exiis; 05-12-2021 at 04:44 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Average every other nth row

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Average if values in adjacent columns is >0 AND adjust the average range each time
    By ew17 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2020, 12:56 PM
  2. Help with averageifs formula.
    By LorenzoCastroC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-02-2020, 12:44 PM
  3. [SOLVED] Taking the average of multiple groups of cells with ability to extend range of average
    By 2597Gar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2019, 11:07 AM
  4. Replies: 5
    Last Post: 09-11-2018, 10:29 AM
  5. Replies: 2
    Last Post: 04-17-2018, 09:45 PM
  6. Replies: 14
    Last Post: 06-14-2013, 09:00 PM
  7. The rank of average ranks excluding empty cells but including their average.
    By Terminal45 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2012, 03:44 AM

Tags for this Thread

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