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

Found a solution

😉

Hello!

Here is my solution:

Agree better to use a static reference table.

2 solutions

I need to practice the first 2 steps a lot more, took ages to get the data split and fill the empty rows. The next part was ugly

Thanks

Used the Multi-Row Formula (x2) and Switch statement to solve this one. I had to make some assumption of the order of the months in the Switch statement.

Challenge 21.png

Easy Peasy!