Hi. I'm not sure this is possible but here goes. And thanks in advance for any insight, even if that insight is "you can't".
I have a number of dynamically sized, named arrays that I want to repeat in a column. For instance, the baseline array might have four values in a column (representing 4 weeks of a repeating 4-week cycle), but if the end user decides the cycle is 5 weeks, the array expands to 5 cells.
I want to repeat the array in a single column. Thus if the cycle is 4 weeks, the same 4-value sequence repeats every four cells in the column. Then if the array expands to 5 cycles... you get the idea.
Is there a formulaic way to do this? Trying to avoid VBA but I'll do that if I must (and can probably figure that out on my own but if you have some code on hand, well, I won't say no to it
I have a number of dynamically sized, named arrays that I want to repeat in a column. For instance, the baseline array might have four values in a column (representing 4 weeks of a repeating 4-week cycle), but if the end user decides the cycle is 5 weeks, the array expands to 5 cells.
I want to repeat the array in a single column. Thus if the cycle is 4 weeks, the same 4-value sequence repeats every four cells in the column. Then if the array expands to 5 cycles... you get the idea.
Is there a formulaic way to do this? Trying to avoid VBA but I'll do that if I must (and can probably figure that out on my own but if you have some code on hand, well, I won't say no to it
