How to repeat cell downwards in a column?

  • Thread starter Thread starter Fion
  • Start date Start date
F

Fion

For example, the cell I need to repeat is A1 ie MS, the number of times to
repeat is 20 times ie B1 and the result in column C, ie automatically filled
with 20 cells of MS.
Is there any formula to do this?

A1 | B1 | C1 |
-----------------------------
MS | 20 | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
| | MS |
 
Not quite sure what else is involved, but you could hold the following
formula in all the cells in column C, or as many cells as yo think
you'll ever need.

=IF(ROW()<=B$1,A$1,"")

Regards


For example, the cell I need to repeat is A1 ie MS, the number of
times to repeat is 20 times ie B1 and the result in column C, ie
automatically filled with 20 cells of MS.
Is there any formula to do this?
Click to expand...
A1 | B1 | C1 | ¾  ­­­­­­­­­­­­­­­­­­­­­­­­­­­­­
MS | 20 | MS |
Click to expand...
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ      | MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |
¾           ÿ         ÿ  MS |

­­ 
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo
 
Back
Top