Results 1 to 26 of 26

Rolling Calculation

Threaded View

  1. 09-12-2023, 09:41 AM #1
    ZDR23
    ZDR23 is offline
    Registered User
    Join Date
    12-13-2021
    Location
    Chicago, Illinois
    MS-Off Ver
    365
    Posts
    23

    Rolling Calculation

    Hi everyone.

    I've provided an example of what I'm trying to achieve. Each month new revenue is added and I have to constantly shift my formulas over to compare month over month, year over year, compared to 6 months, and 12 months in columns W-Z. Is there a way to automate when new month data is added to shift the formulas over?
    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. 12 month rolling calculation
    By debony in forum Excel General
    Replies: 5
    Last Post: 11-06-2019, 01:19 PM
  2. Rolling AFR calculation
    By Callingavan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2013, 05:57 AM
  3. Rolling Depreciation Calculation
    By BW78 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2013, 04:47 PM
  4. Rolling weeks calculation
    By portucale in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-23-2012, 07:21 AM
  5. [SOLVED] Rolling Calculation
    By Northumberland81 in forum Excel General
    Replies: 3
    Last Post: 06-05-2012, 07:18 AM
  6. Excel 2008 : YTD Rolling calculation
    By samjam in forum Excel General
    Replies: 0
    Last Post: 07-25-2011, 01:20 PM
  7. Rolling calculation
    By tanksalevikrant in forum Excel General
    Replies: 1
    Last Post: 01-20-2008, 01:02 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