+ Reply to Thread
Results 1 to 8 of 8

Average only from second column value onward for consecutive 10 columns

  1. 11-01-2022, 07:43 AM #1
    rickytripleh
    rickytripleh is offline
    Registered User
    Join Date
    04-29-2020
    Location
    Kuala Lumpur
    MS-Off Ver
    365
    Posts
    13

    Average only from second column value onward for consecutive 10 columns

    Hi All Experts~

    Good day!

    I have rows of different IDs and about 18 weeks in column

    I need help for a set of formula to get consecutive 10 weeks average number, but only starts from second column with value on each ID respectively

    Attached herewith the sample workbook

    Thank for the helps in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-01-2022, 08:15 AM #2
    HansDouwe
    HansDouwe is online now
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: Average only from second column value onward for consecutive 10 columns

    An option:

    Please try in A2 and copy down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by HansDouwe; 11-01-2022 at 08:17 AM.
    Reply With QuoteRegister To Reply
  3. 11-01-2022, 08:15 AM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Average only from second column value onward for consecutive 10 columns

    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 11-01-2022, 08:18 AM #4
    XLent
    XLent is offline
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Average only from second column value onward for consecutive 10 columns

    and, another...

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 11-01-2022, 12:03 PM #5
    rickytripleh
    rickytripleh is offline
    Registered User
    Join Date
    04-29-2020
    Location
    Kuala Lumpur
    MS-Off Ver
    365
    Posts
    13

    Re: Average only from second column value onward for consecutive 10 columns

    Hi Hans,

    Thanks and it's exactly what i'm looking for
    Reply With QuoteRegister To Reply
  6. 11-01-2022, 12:04 PM #6
    rickytripleh
    rickytripleh is offline
    Registered User
    Join Date
    04-29-2020
    Location
    Kuala Lumpur
    MS-Off Ver
    365
    Posts
    13

    Re: Average only from second column value onward for consecutive 10 columns

    Hi XLent

    Thanks and it works perfectly~
    Reply With QuoteRegister To Reply
  7. 11-01-2022, 12:16 PM #7
    HansDouwe
    HansDouwe is online now
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: Average only from second column value onward for consecutive 10 columns

    Glad to help, thanks for the feedback and rep .
    Reply With QuoteRegister To Reply
  8. 11-01-2022, 12:16 PM #8
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Average only from second column value onward for consecutive 10 columns

    Glad to help & thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to count consecutive responses - text in two columns with response in one column
    By smide in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-15-2017, 09:47 AM
  2. [SOLVED] Searching for the first four consecutive columns with values then getting the average
    By renzda2nd in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-10-2016, 07:57 AM
  3. How to get combinations from values of one excel column in consecutive columns
    By jassipox in forum Excel General
    Replies: 5
    Last Post: 02-07-2014, 02:33 AM
  4. [SOLVED] Consecutive average in column into Microsoft Excel
    By taposh.roy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2013, 03:56 AM
  5. [SOLVED] How do I transpose values in consecutive columns so that they fall into the first column?
    By zicitron in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2013, 10:04 AM
  6. [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
  7. print from second row onward
    By sanlen in forum Excel General
    Replies: 0
    Last Post: 02-24-2011, 05:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1