Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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

mithily
8 - Asteroid
Spoiler
not sure i get the exact names as the output but it was interesting to transpose and not do separate multirow for each measure
Brinker
8 - Asteroid

Thanks, great excercise!

KellyWray
5 - Atom

Attached is my answer for Challenge 3.

ntakeda
11 - Bolide

I didn't know what to do.

Spoiler
ntakeda_0-1687494380533.png

 

jstewa13
7 - Meteor

This one was tricky, originally tried to do the rolling avgs before the first transpose, once i saw you had to do it after everything fell into place 

AImbody
8 - Asteroid

I can't insert my screenshot so my file is below.  I was actually very confused by the format of the given answer so what I came up with looks completely different.

danielhoge
8 - Asteroid

It doesn't look like the output file, but I think the numbers are correct. Followed the instructions instead of duplicating the provided solution.

MatteoReddavide
8 - Asteroid

My solution, it seems the same even with a different final structure

 

Spoiler
Screenshot 2023-07-14 112934.png
Krzysztof_Hyla_1986
8 - Asteroid

Solved this using 'Multi-Row Formula' twice.

Spoiler
challenge_3_solution_KH.jpg
Danielle_Lutz
7 - Meteor

Solution