Challenge #432: Sequential Logic

[mmontgomery]

c432

Spoiler

Did an iterative macro, no multi-row

[Tofel]

Spoiler

 

[sfarnham1]

First time with an iterative macro

[HardikJani]

Hi, thanks for a good challenge. I first created three dummy columns as per the rules then I created a macro to fill the rows using three multi row tools and then recreated the dummies. Looped this for 22 times to get the data and filtered the unwanted rows and columns 

[JAKupchik]

Great challenge :-) .  Makes for good practice with some of the more powerful tools and not getting lost in the challenge/purpose details.  Thanks!  JAK

[tammybrown_tds]

Logic puzzles are fun.

Spoiler

[Powerhouse_21]

Spoiler

[Qiu]

@AkimasaKajitani 
Nice way of thinking. 😁

[mkeiffer]

Spoiler

 

My solution!

[Smatthias]

Spoiler

Spoiler

Somebody know how to use just one multi line expression rather than 4, like calc all columns in one? Anyway, solution is simple, take the last row, which is the only relevant row, A is the sum of all, hence for further calc you just calc [row-1:A]*2. Then you calc the rest based on the last relevant row. Reattach the solution with the previous rows and voila, solution. I used an excel to read in the data.My Solution: