Hello guys, I have the following issue:
I got Columns B with number of users added per month(Months In Column A) and in D Column I have the percentage of people that stop being users by each month that passes(For example there will be only a 92% of users that entered 3 months ago).
I need to find out the amount of active users each month. So for example if Im calculating Month number 3, it should multiple Amount of Users added in Month 3 by 100%, added users in Month 2 multiplied by 96%, and added users in month 1 multiplied by 92%.
I'm really frustrated about this one and I need help, thank you guys!
I got Columns B with number of users added per month(Months In Column A) and in D Column I have the percentage of people that stop being users by each month that passes(For example there will be only a 92% of users that entered 3 months ago).
I need to find out the amount of active users each month. So for example if Im calculating Month number 3, it should multiple Amount of Users added in Month 3 by 100%, added users in Month 2 multiplied by 96%, and added users in month 1 multiplied by 92%.
I'm really frustrated about this one and I need help, thank you guys!