Free Trial

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

CoG
14 - Magnetar

Getting the Batch Macro was a little trickier for me than I anticipated. Great learning exercise!

 

Main Workflow:

Spoiler
Workflow_Main.png

 Batch Macro:

Spoiler
Workflow_BatchMacro.png
ds_tomalexsmith
8 - Asteroid
Spoiler
Challenge 17 (flow).pngChallenge 17 (macro).png

  

Rob-Silk
8 - Asteroid

My solution below:

Spoiler
challenge_17a_RS_screencap.PNGchallenge_17b_RS_screencap.PNG
Myles_Stevenson
8 - Asteroid

Here is the macro i made for the solution along with the workbook 

Spoiler
Screenshot 2023-12-04 144309.png

alexnajm
17 - Castor
17 - Castor

Done!

Spoiler
Challenge 17.PNG
caitlynmcintyre
9 - Comet

no need for a batch macro :)

 

Spoiler
17.png
BrianJohnson
8 - Asteroid

After starting exercise, I watched the interactive video again to help to turn it into a batch macro.  I went well and I appreciate the lesson.

sknman92
8 - Asteroid

my solution

SGrasland
7 - Meteor

I am finding macros to be a challenge! 

cecilysantiago
6 - Meteoroid