+ Reply to Thread
Results 1 to 8 of 8

Simplifying cohort analysis formula in 1 row

  1. 03-06-2024, 07:56 PM #1
    Yookii is offline
    Registered User
    Join Date
    07-19-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    14

    Simplifying cohort analysis formula in 1 row

    Hi All

    I am trying to simplify a cohort analysis that requires multiple steps and formula into 1 row.

    1. There are new users coming in particular month (row 3)
    2. Every time you have new users, each cohort will decay at y = x^(-1) with y the new cohort intake and x the number of months (row 5-7)
    3. I add all the decay together to get to the total (row 8).

    Can you help me find a formula in row 10 that replaces total into a formula that fits into one row as opposed to having to create multiple rows for each new cohort intake? ie a formula that only uses row 1 and 3.
    The formula needs to be the same from B10 to M10. A formula in B10 that I can drag to M10.


    Many thanks
    Yooki

    Book1.xlsxScreenshot 2024-03-07 105252.png
    Last edited by Yookii; 03-06-2024 at 08:35 PM.
    Reply With QuoteRegister To Reply
  2. 03-06-2024, 08:25 PM #2
    DJunqueira is offline
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Simplifying cohort analysis formula in 1 row

    Not sure if this is what you want.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 03-06-2024, 08:32 PM #3
    Yookii is offline
    Registered User
    Join Date
    07-19-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Simplifying cohort analysis formula in 1 row

    I forgot to add that the formula CANNOT change so should be the same from B10 to M10.

    In your example B13, E13, and G13 are different.
    Reply With QuoteRegister To Reply
  4. 03-06-2024, 08:33 PM #4
    Yookii is offline
    Registered User
    Join Date
    07-19-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Simplifying cohort analysis formula in 1 row

    I need a formula that I can drag to the right from B10 to M10.
    Reply With QuoteRegister To Reply
  5. 03-07-2024, 01:53 AM #5
    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,514

    Re: Simplifying cohort analysis formula in 1 row

    Are you still using Excel 2010? Or have you perchance upgraded to 365?
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 03-07-2024, 02:05 AM #6
    Yookii is offline
    Registered User
    Join Date
    07-19-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Simplifying cohort analysis formula in 1 row

    yes i am on 365
    Reply With QuoteRegister To Reply
  7. 03-07-2024, 02:17 AM #7
    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,514

    Re: Simplifying cohort analysis formula in 1 row

    Then please update your forum profile. Please do this NOW.
    Reply With QuoteRegister To Reply
  8. 03-07-2024, 05:55 AM #8
    DJunqueira is offline
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Simplifying cohort analysis formula in 1 row

    Quote Originally Posted by Yookii View Post
    yes i am on 365
    That makes a big difference...
    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] Help with calculation of customer retention rate in Excel file (Cohort analysis)
    By tuanvu in forum Excel General
    Replies: 2
    Last Post: 11-03-2018, 12:17 PM
  2. Cohort Analysis help needed
    By Vikas Panwar in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-21-2016, 12:21 PM
  3. Simplifying a Formula
    By civram1982 in forum Excel General
    Replies: 3
    Last Post: 01-28-2016, 04:31 AM
  4. Cohort Analysis: Summing Quartiles of Data with Specific Condiitons
    By augensmj in forum Excel General
    Replies: 2
    Last Post: 09-10-2015, 05:34 AM
  5. Simplifying a formula
    By Darren88 in forum Excel General
    Replies: 9
    Last Post: 02-26-2012, 04:27 AM
  6. Simplifying gap & repetitive items analysis
    By wallywalter in forum Excel General
    Replies: 2
    Last Post: 01-20-2011, 02:54 AM
  7. Simplifying a formula
    By neilpateluk in forum Excel General
    Replies: 3
    Last Post: 01-14-2009, 09:25 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