+ Reply to Thread
Results 1 to 2 of 2

12 weeks rolling average

  1. #1
    Forum Contributor
    Join Date
    06-25-2013
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    114

    12 weeks rolling average

    Hello Everyone

    I am trying to get the 12 weeks of rolling average in the attached file. can any one suggest any function which helps doing it. Attached is the sample

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,410

    Re: 12 weeks rolling average

    A 12 week rolling average of what? You've highlighted one cell. What do you expect the result to be in that highlighted cell?

    You could use:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    for the first line.

    Then drag down. Is that what you are looking for? There can't be any gaps.


    Regards, TMS
    Last edited by TMS; 02-18-2014 at 05:28 AM. Reason: Edit formula
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Help! Rolling Chart to only show the most recent four weeks
    By hermes5187 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-10-2013, 02:07 PM
  2. Reverse rolling weeks from today's date?
    By BabySkates in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2013, 02:44 PM
  3. Get maximum frequency in 9 weeks rolling period
    By baltblue in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2013, 11:37 AM
  4. Rolling weeks calculation
    By portucale in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-23-2012, 07:21 AM
  5. Rolling Totals for Several Weeks
    By acedie in forum Excel General
    Replies: 9
    Last Post: 08-29-2008, 11:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1