How Do I Repeat the Value in a Cell over a Stated Number of Cells?

**Kentle** · 11-01-2011, 02:21 PM

Here is my dilemma...
I need to repeat a value in a cell 2 columns over multiplied by the value in said cell.
For example, I need the value in E23 (13) repeated in E25, E27, E29 etc. a total of 13 times.
I have researched everywhere and cannot resolve this.
Any assistance would be apreciated.

**NBVC** · 11-01-2011, 02:29 PM

You can use a formula like:

=IF(AND(MOD(ROW(),2)=1,ROWS($E$25:$E25)/2<=$E$23),$E$23,"")

copied down as far as you want... the rows after the count in E23 will be blank..as well as the ones in between.

**Kentle** · 11-01-2011, 10:01 PM

Thanks NBVC...
I copied and pasted the formulas into the cells I needed but the count doesn't seem to end at the specified number. Am I missing something?