Multi-Row Formula with Dynamic Range, or Batch Macro

Giles

I'm looking to re-create an XL tool I have (which uses VBA For/Next loops) in Alteryx.

Given a set of A values, of size n, I need to calculate B and C, where:

I've got a solution for calculating B (using a variety of indexing, appending, and multi-row formulae), but I'm wondering how best to proceed with a solution for C.

Is what I'm looking to achieve possible with (dynamic range) multi-row formulae? Should I be looking into batch macros instead?

Assistance would be appreciated.

ivoller

@Giles  This looked like a great test case for macros so I built a flow that way (see below). As to the question re doing it with multi row formulae wtc, I'm sure that someone cleverer than me will come up with a way but the macro solution was fun :-)

ABC Tool.yxzp