Challenge #374: Using Iterative Macros

[TimJVR]

Spoiler

Tried it a few ways, but this one is the easiest. With comments for those who are interested. 

[benjimoser]

My Solution

Spoiler

[Qiu]

Fun one!

Spoiler

[Flo_P]

Spoiler

Learning experience!

[BS_THE_ANALYST]

The fact the Text Input was a Byte caused issues for me. First time I've had to leverage the 'Forced Int64' datatype - props to @TheOC for pointing that out. I like the idea of leveraging a Text Input with a Union to force the agenda as an alternate route to address this issue. 

Spoiler

[Towers]

my solution

Spoiler

[wdula]

Spoiler

It took me way longer than I care to admit to realize that the calculations in the formula tool are done in order and not in parallel.

First time making an iterative macro too, lots of learning this week!

  

Spoiler

  

[MitchellBliesner]

I've failed the advanced exam once and I failed the macro practical question. If I had gotten it right I would've passed so I'm going to practice macro questions and try again to get the certification. Anyway, here is my solution to the challenge.

Spoiler

[TurboToad]

Started with a batch macro solution since I'm more familiar with those. 

Spoiler

Batch Solution:

Iterative:

[dhovey]

Good example for practicing iterative macros. Open to any constructive criticism.