Challenge #432: Sequential Logic

[3I_ATLAS]

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]

Challenge Completed

Spoiler

[myastarling]

Here's my solution!

[alineruizcampos]

Spoiler

[Sebastian_Chaieb2]

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

Spoiler

 

[claw7444]

Here is my solution

[Spainey]

A very fun challenge :)

Spoiler

I did originally think Iterative macro, but then settled on the Transpose/Crosstab technique which allowed me to use a single Multi-Row Formula tool to calculate each column in sequence.

[Saranya1995]

Here is my solution!

[CeliaC_Silje]

Love this challenge <3

Spoiler

challenge432

[DanielG]

Solved