We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #264: Sliding Totals

phottovy
11 - Bolide

Like others, my instinct was to go with a batch macro, so I may have had a quick peak at @Aaron_Harter's solution. Much simpler approach:

 

Spoiler
264.PNG
Spalders
8 - Asteroid

Going for the record number of multi-row formula tools in the solution 🙂

Spoiler
Spalders_1-1618846977752.png

 

Ladarthure
13 - Pulsar
13 - Pulsar

My solution, fun way to write data 🙂

Maskell_Rascal
12 - Quasar

Fun challenge to start the week!

 

RaviP
8 - Asteroid

Here's my solution. Was able to complete it with 4 objects 🙂

Spoiler
RaviP_0-1618847653826.png

 

  

luisedo
5 - Atom

Nice one! @RaviP  Not the most intuitive but very simple.

AngelosPachis
15 - Aurora

Nice quick challenge for this week, great use case for the First and Last functions of the Summarize tool.

 

Spoiler
AngelosPachis_0-1618853015078.png

 

 

Toons
11 - Bolide

My solution (with a batch macro) :

 

Spoiler
Toons_0-1618853282605.pngToons_1-1618853297784.png

 

 

abrouwer
8 - Asteroid

Solution attached

Spoiler
Capture.PNG
Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1618855323173.png



macromacro