Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #17: Month-over-Month Retention Rate

Reesetrain2
9 - Comet

All,

 

My solutuion after many a trial-and-error!

-Cheers!

Spoiler
Capture.PNG
Alekh
9 - Comet

 

Spoiler
17..png

 

David-Carnes
12 - Quasar

Pretty straightforward.  The only "oh, duh" moment came when I realized I had left out part of the equation to enumerate the accounts open at each month.  I had thought it through when examining the data but spaced on it during the actual crafting of the macro.

 

Spoiler
017.png

batch_107.png
ADerbak
11 - Bolide

Solution Attached!

Niklas
8 - Asteroid

Wanted to try without the macro, the solution for tracking previous cancellation isn't as scalable / resilient as I'd like, but it works. 

Eleonora
8 - Asteroid

My solution

 

 

Spoiler
challenge 17 solution Eleonora Nazander.JPG
FRANCK_ROUQUETTE
8 - Asteroid
Thank You for the exercise - please find attached my proposed solution.
Vidya26
8 - Asteroid

My Solution!!

Tom_Luthi
8 - Asteroid

solution attached.

ConradW
8 - Asteroid

17-complete