create dynamic array based on cell references, number of times to repeat and length

[exceluser321a]

Hi,

I'm trying to create an array (which will be ultimately used in a formula e.g. NPV) of cell references which repeat themselves (which will be dependent on another cell reference). The range of cell references to be repeated will also be dependent on another cell reference. Sorry if I didn't articulate this well. I've attempted to illustrate an example below:

[TABLE="width: 200"]
<tbody>[TR]
[TD]Length[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Amount 1[/TD]
[TD]100[/TD]
[TD]110[/TD]
[TD]110[/TD]
[TD]110[/TD]
[/TR]
[TR]
[TD]Repeat Amount 1 By[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Amount 2[/TD]
[TD]110[/TD]
[TD][/TD]
[TD][/TD]
[TD]115[/TD]
[/TR]
[TR]
[TD]Repeat Amount 2 By[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Returned Array[/TD]
[TD](100,100,110,110,110,110,110,110,110)[/TD]
[TD](110,110,110)[/TD]
[TD](110,110,110,110,115,115)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance.