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

alex2017
7 - Meteor

My solution is attached. This didn't seem clear from the "goal" paragraph, but I guess the objective is to only group by HP Category for the 3-month average?


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

TimothyManning
8 - Asteroid

Started down the long road of 12 multi row formula tools, and then realised it was a terrible idea


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

FeedMeData
8 - Asteroid

My solution attached!


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

matyohan
9 - Comet

 My late solution attached


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

JonathanAllenby
8 - Asteroid

Here's my solution to Challenge 3!


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

hanykowska
11 - Bolide

Nice one! Hope to try and do it with a macro once I learn that... here's my solution for today.

 

Also in the description in the comment block there's a mistake in the explanation of running average.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

megha1311
6 - Meteoroid

My solution to challenge 3.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Bunny82
6 - Meteoroid

Multi-row exercise with some cross tab sprinkled on top.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

hanykowska
11 - Bolide

That was a bit of a false start... Corrected solution below.

 

As some have mentioned, the r6mo calculations seem not to group by HP category so this is what might differ with my solution.


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

PadmajaS
7 - Meteor

Good Challenge!


This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.