+ Reply to Thread
Results 1 to 3 of 3

Quarterly Growth Rate over different years

  1. 09-01-2021, 05:08 AM #1
    zahra2309 is offline
    Registered User
    Join Date
    09-01-2021
    Location
    iran
    MS-Off Ver
    2016
    Posts
    1

    Quarterly Growth Rate over different years

    Dears,

    I have some data like the attached excel file and I want to calculate the sales quarterly growth rate for different products in different years. for example, I want to calculate the sales growth rate of shoes in 1993 quarter1 regarding the previous year and quarter which is the year 1992 and quarter 4.


    Any helps and advice are highly appreciated.

    thank you in advance,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-01-2021, 06:42 AM #2
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Quarterly Growth Rate over different years

    Hi and welcome to the forum.

    Does the attached help
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 09-01-2021, 09:22 AM #3
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: Quarterly Growth Rate over different years

    1993Q1 vs 1992Q4, what happen if no 1992Q4? Do you want to compare with 1992Q3?
    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 trend line growth rate (as an annual percentage growth rate)
    By rrurban in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-02-2020, 01:39 AM
  2. [SOLVED] Returning Quarterly sales figures with growth factor
    By mugelbbub in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-14-2019, 05:42 AM
  3. Compound growth rate (Getting monthly rate from annual growth rate)
    By rsbrais in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2017, 04:35 PM
  4. sales growth vs. headcount growth for recent years
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-15-2015, 04:24 AM
  5. Percentage Growth between two years
    By debbiesap in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-27-2014, 08:59 AM
  6. Annual Growth Rate set over 25%, actual rate is greater than assumption
    By hlep in forum Excel General
    Replies: 1
    Last Post: 06-18-2012, 04:08 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