Challenge #17: Month-over-Month Retention Rate

[wdavis]

Completed with the Macro addition

[Treyson]

I added a bit to this, where if you so desired you can have the workflow continue to change the ranges that it's checking for as time goes on. That way, when we are running this next month, we don't have to add any parameters to our text input table.

[TonyA]

Here's my solution.

[Jonathan-Sherman]

Challenge 17 is done!

Spoiler

[JennyMartin]

Spoiler

Great for batch macro practice.

[Bluemoon]

A bit messy, but gets the job done...

Spoiler

[Koji_B]

Solution attached.

Answer requires % closed rather than % retained

[jusdespommes]

This one broke me - I think it would have been a lot easier if the rules were bulleted at the start i.e. if closed before then can't be open in the future etc.

Ended up using an iterative macro. All done anyway 🙂

Spoiler

[Assaf_m]

Solution attached