Challenge #432: Sequential Logic

[cmoussa]

[robert-headington]

#432

[martinson]

Heavy influence from RolandSchubert

[lidailida]

😊

[SamBreen]

Spoiler

Workflow above and formula logic below :)

 

 

Spoiler

[GGGDias]

i followed that same approach but it would never work because A is the supposed to be sum of A B and C of the previous row.

I'm not sure you noticed, but even though your formula gave the same result as the answer, it did not actually followed the challenge's formula of " Column A: Calculate the sum of all numbers in the previous row."; which I believe might only be achievable via macro, right?  Do you know if there would be any other way to iterate through the records like that, assigning values to multiple fields without a formula?  Just wondering...

Thanks Roland!

[GGGDias]

Very few people found the given solution for this problem (without using Transpose and Crosstab instead), which comes as no surprise as it is a very cryptic solution if you ask me.  More laborious but way simpler to implement with a macro.  Without the macro this is a simple yet wicked challenge if you ask me.  Cheers!

[GGGDias]

Dirty??!  you should feel proud as you were one of the very few who found this wicked solution with cross tab and transpose, which was the true (no macro) solution to this wicked challenge.  Anyone can do it via macro, but takes ingenuity to figure it out how to solve it without.  Kudos to you TurboToad!

[PhilipMannering]

Solution attached...

Spoiler

[mgaronson]

Spoiler

 This was a little tricky for a basic challenge. Took a while to figure the trick out.