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 #264: Sliding Totals

CHarrison
8 - Asteroid

My solution :)

JennyMartin
9 - Comet
Spoiler
AWC264M.PNGAWC264.PNG

Decided to overcomplicate matters with a batch macro! Video solution here: https://youtu.be/_hEzQEnaT_w

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1658500141564.png

 

Few different options on this one but went with the one where I could use the most multi-row formulas. Any excuse is a good excuse

MilindG
12 - Quasar
Spoiler
MilindG_0-1659118858647.png

 

ARussell34
8 - Asteroid

This is a very odd way of keeping track of rolling amounts, but alas didn't stop me from solving it.

acarter881
12 - Quasar

Here's my solution.

Spoiler
my_weekly_challenge_264_solution.png
martinding
13 - Pulsar

This was a hard one to wrap my head around

DataNath
17 - Castor

My solution to #264.

 

Spoiler
DataNath_0-1667748997001.png
karlhansen
9 - Comet
Spoiler
solution_264.jpg
ZacharyRyanTIL
8 - Asteroid

solved