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

Another non-macro solution. Transpose to get all the required values in one column and then multi-row the bejeebers out it. I interpreted the problem to be rabbits can start reproducing at 4 months old, but have a 1 month gestation period. The first clutch of rabbits is born at the start of month 5

solution 123.png

Dan

My interpretation of the problem lands me with 01/02/2022 as a few others have, but go go multi-row formulas!

That was a fun one! It definitely took some thinking. Cheers!

Challenge Completed

After looking at some of the other solutions, I regret not using a custom bunny icon for my macro!

Main workflow:

Iterative macro:

After looking at some of the other solutions, I regret not using a custom bunny icon for my macro!Main workflow:Iterative macro:

Here is my solution...

Same month... slightly off numbers...

Got the same date but numbers are slightly different!

Solved at long last. Quite a few false starts until I figured out how to group the iterating output correctly.

Screenshot 2018-12-29 at 21.40.18.png

Screenshot 2018-12-29 at 21.41.35.png

My solution, used the macro approach

Didn't get the exact same numbers but got the same month.