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 #3: Running Averages

chirimoyayachay
8 - Asteroid

very confusing challenges, it says 3monthavg and 6monthavg,

but the output only showing 3 right

 

MohammadTajunnisa
6 - Meteoroid

Finally completed...But still confused with the output as it is tough challenge 

Raj
16 - Nebula

Solved!

 

Challanges are always fun to solve.

sbradley
5 - Atom

Done! 😥

kaiserj
8 - Asteroid

done 🙄

adam_speed
7 - Meteor

skipping this one.  the solution output is confused.  may circle back in the future.

vmazur24052020
8 - Asteroid

Easiest but brute force (via Multi-Row Formulas)

YuichiroSuzuki
8 - Asteroid

confused :(

Spoiler
スクリーンショット 2024-05-23 233837.png
alycar
5 - Atom

This was definitely a bit confusing, but it is nice to revisit multi row formula!

Szymon_Czuszek
8 - Asteroid

Attached my result. I feel like the provided solution is incorrect, so I modified the output using my own judgement.

 

Workflow:

Spoiler
WeeklyChallenge3.PNG

Macro:

Spoiler
WeeklyChallenge3Macro.PNG