Start Free Trial

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 #432: Sequential Logic

Shifty
12 - Quasar

Boggled my noggin for a while! 🤓

Spoiler

432sr.jpg
a640687
8 - Asteroid
Spoiler
Capture.PNG
Carolyn
12 - Quasar
12 - Quasar

Solved! My first thought was an iterative macro but since this is marked as Basic/Core, I went with a more Basic/Core solution :) 

 

Spoiler
2024-07-23_09-57-12.png

MitchyMitch
8 - Asteroid

I think the wording of this challenge is a bit more confusing than intended. Once I started analyzing the output, it became clearer. Either way, great chance to practice multi-row formulae! 

Spoiler
Challenge 432.png
Dev73
8 - Asteroid

Great challenge 😊challenge 432.jpg

KevinMcCoy
5 - Atom

Iterative Macro ftw

Desmond
9 - Comet

My solution

ahsanaali
11 - Bolide
Spoiler
432.png432_1.png

  

TheOC
16 - Nebula
16 - Nebula

Figured it would be interesting to try to avoid an iterative/batch macro....

Spoiler
 

My Image uploads are still bugged, but i was able to leverage a multi-row formula to do the calculations after pivoting. Likely not the way I would do it in a practical setting and I would typically opt for an iterative macro.

 

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
KRueckemann
7 - Meteor
Spoiler
Capture.PNG