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

phottovy
13 - Pulsar
13 - Pulsar

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
14 - Magnetar
14 - Magnetar

My solution, fun way to write data 🙂

Maskell_Rascal
13 - Pulsar

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
16 - Nebula

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
12 - Quasar

My solution (with a batch macro) :

 

Spoiler
Toons_0-1618853282605.pngToons_1-1618853297784.png

 

 

abrouwer
8 - Asteroid

Solution attached

Spoiler
Capture.PNG
Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1618855323173.png



macromacro