+ Reply to Thread
Results 1 to 3 of 3

Calculate Moving Average of last 5 and last 3 Rows

  1. 10-06-2021, 05:57 PM #1
    RollingDice
    RollingDice is offline
    Registered User
    Join Date
    11-01-2018
    Location
    Mexico City
    MS-Off Ver
    2016
    Posts
    30

    Calculate Moving Average of last 5 and last 3 Rows

    Can you calculate last 5 row in excel without the ctrl+shift+enter (excel array) formulas?

    (see attachment for example)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-06-2021, 06:13 PM #2
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,956

    Re: Calculate Moving Average of last 5 and last 3 Rows

    Yes, you could use two columns of helper formulas if you don't want array formulas.... that is the strength of array formulas.
    Attached Files Attached Files
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
  3. 10-06-2021, 06:44 PM #3
    RollingDice
    RollingDice is offline
    Registered User
    Join Date
    11-01-2018
    Location
    Mexico City
    MS-Off Ver
    2016
    Posts
    30

    Re: Calculate Moving Average of last 5 and last 3 Rows

    Wow, thanks.
    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. How to calculate a moving average
    By omer123456 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2018, 04:18 AM
  2. Calculate a 30-day moving average based on the last x number of entries and date
    By gimiv in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-26-2016, 11:52 PM
  3. Formula to calculate a moving average
    By lwandjaw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2016, 03:17 AM
  4. Moving down cells until date changes then calculate average
    By jfrank1034 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2014, 12:26 PM
  5. How to Calculate Moving Average from top of list for first 10 rows?
    By freda in forum Excel General
    Replies: 2
    Last Post: 03-15-2014, 07:28 AM
  6. How to calculate sum of a moving range and average it
    By a_driga in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-27-2011, 02:17 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