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
アステロイド

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

but the output only showing 3 right

 

MohammadTajunnisa
メテオロイド

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

Raj
ネビュラ

Solved!

 

Challanges are always fun to solve.

sbradley
アトム

Done! 😥

kaiserj
アステロイド

done 🙄

adam_speed
メテオール

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

vmazur24052020
アステロイド

Easiest but brute force (via Multi-Row Formulas)

YuichiroSuzuki
アステロイド

confused :(

スポイラ
スクリーンショット 2024-05-23 233837.png
alycar
アトム

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

Szymon_Czuszek
アステロイド

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

 

Workflow:

スポイラ
WeeklyChallenge3.PNG

Macro:

スポイラ
WeeklyChallenge3Macro.PNG