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

GGGDias
8 - Asteroid

Maybe I'm reading too much into this but i think the real challenge/puzzle is to find out the way to do it WITHOUT macros and ALSO calculating the values AS PER the formula prescribed (in which values depend on the 2 other fields in the prior row).  I suspect Patrick Digan (@patrick_digan)  gives a tip under the 'Need a refresher' section.

I must admit i couldn't figure it out and i thought this would only be possible with a macro, however  @RashedDS posted a perfect solution with no macros.

Congrats  @RashedDS!  and Thanks Patrick for this interesting puzzle!  

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

 

Spoiler
Screenshot 2025-01-25 164152.png
myastarling
10 - Fireball

Here's my solution!

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-02-04 140640.pngScreenshot 2025-02-04 140646.png
Sebastian_Chaieb2
10 - Fireball
10 - Fireball

My solution is very easy just working on 2 levels of rows as sum will be always the same 

Spoiler
432.png