Results 1 to 8 of 8

Average only from second column value onward for consecutive 10 columns

Threaded View

  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
« 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