Multi-Row Formula with Dynamic Range, or Batch Macro
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Batch Macro
- Developer
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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 :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's terrific, @ivoller, thank you. I have numerous similar scenarios which will require solutions, and I will be developing them using your methodology as a template.
I look forward to being as helpful to other members of this community, as you have been to me.
