cohort

  1. M

    Copying Data from one sheet to another based on certain cell data

    Hi everyone, I have a query about copying data from one sheet to another based on a range of data in a certain column. I have created an assessment grades workbook which contains a number of sheets. Each sheet represents a module on the course, and also contains a stats sheet and a cohort...
  2. J

    Cohort Survival - weighted cohort?

    I’m trying to track cohort survival through a training program. One issue I am struggling with is the impact of the cohort size on how that displays in the data. The course is quite demanding so there are always going to be losses. for example: cohort 1 has 100 students and at a point, 1...
  3. R

    Cohort Waterfall by account count

    I am trying to build out a waterfall that will count how many customers we have based on what time they became a customer. The plan is to count the account IDs if they are new business and remove them if they have been cancelled. The issue is an account can have numerous opportunities marked as...
  4. W

    From Shopify to Excel: cohort analysis, last step missing

    Hi, A quick one. I have Shopify, and get the following raw data: customer ID, date of purchase and amount (€) I would like to perform a cohort analysis <colgroup><col><col><col><col></colgroup><tbody> Client ID Date Amount Date of 1st purchase 68 Jan-15 € 7,979...
  5. T

    Sum value on long cohort size

    I got a cohort follow this google sheet https://docs.google.com/spreadsheets/d/1sPwOg_YIVQ_b0IN7q3bQHyfRKQ42MA4ayfP77HpkvGs/edit#gid=0 I wanted to sum the value like some of example listed, this could be done with simple forumla and short cohort. But if the cohort length is too long, I don't...
  6. C

    Calculate the last cell as oppose to the first cell

    Good day I am trying to calculate some data in excel and I urgently need some assistance in getting the formula to work well. Issue: A1 B1 80 100% 96% 80% 60 69% 50% 50% 50 70% 40% 20% 63 55% 30% 50 69% So based on the example above, I am trying to sum the data in column A while dragging...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top