+ Reply to Thread
Results 1 to 7 of 7

Month on Month Increase %

  1. 07-20-2018, 07:34 AM #1
    Rushendra
    Rushendra is offline
    Registered User
    Join Date
    06-25-2015
    Location
    HYDERABAD
    MS-Off Ver
    2013
    Posts
    46

    Month on Month Increase %

    Dear Team,

    Please help me out with the calculation for Month on Month Increase %.

    Attached is the data of the Total Customers for different Service type, I want to calculate the Month on Month Increase % in Row A12 (MoM%) for the Total Unique Customers (RowA11).

    Also request you to please help me with the logic for the calculation.

    Attached is the data

    Regards
    Rush
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-20-2018, 07:37 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,595

    Re: Month on Month Increase %

    You need to add your expected outcomes, calculated manually. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-20-2018, 07:39 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,595

    Re: Month on Month Increase %

    Maybe this in C12 copied right?

    =B11/C11
    Reply With QuoteRegister To Reply
  4. 07-20-2018, 07:42 AM #4
    Rushendra
    Rushendra is offline
    Registered User
    Join Date
    06-25-2015
    Location
    HYDERABAD
    MS-Off Ver
    2013
    Posts
    46

    Re: Month on Month Increase %

    Thanks for quick response,

    I want to know the increase percentage of unique customers from previous month to current Month.

    Please correct me if i am wrong is the below method for calculation for Month on Month Increase formula.

    MoM Calculation formula = (New Value - Old Value) / Old Value

    Regards
    Rush
    Reply With QuoteRegister To Reply
  5. 07-20-2018, 07:58 AM #5
    samba_ravi
    samba_ravi is online now
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Month on Month Increase %

    may be
    C12=(C11-B11)/B11
    Try this and copy towards right
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  6. 07-20-2018, 08:20 AM #6
    Rushendra
    Rushendra is offline
    Registered User
    Join Date
    06-25-2015
    Location
    HYDERABAD
    MS-Off Ver
    2013
    Posts
    46

    Re: Month on Month Increase %

    I there any logic behind it for it please help
    Reply With QuoteRegister To Reply
  7. 07-20-2018, 08:28 AM #7
    Rushendra
    Rushendra is offline
    Registered User
    Join Date
    06-25-2015
    Location
    HYDERABAD
    MS-Off Ver
    2013
    Posts
    46

    Re: Month on Month Increase %

    Quote Originally Posted by nflsales View Post
    may be
    C12=(C11-B11)/B11
    Try this and copy towards right
    Thanks for the calculation
    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. [SOLVED] Auto month increase-
    By thursday140 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2018, 02:30 PM
  2. [SOLVED] Calculation of days per month for dates beginning in one month and ending in another month
    By Fahrettin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 04:52 PM
  3. Macro to increase formulas from the previous month's workbooks into next month's workbook
    By Jeffroth in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2015, 04:43 PM
  4. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  5. Month over Month formula to show increase or decrease in rankings for SEO
    By lindsbay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 03:03 AM
  6. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM
  7. increase one month
    By [email protected] in forum Excel General
    Replies: 5
    Last Post: 03-30-2006, 05:35 PM

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