Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to repeat cell downwards in a column?
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 | |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to repeat cell downwards in a column?
On Jan 11, 4:53*pm, Fion wrote:
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 *| You could enter following formula in C1 and then drag it down as far as you need it: (assuming, that you want to start in the first row!) =IF(ROW()<=$B$1,$A$1,"") hth Carlo |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to repeat cell downwards in a column?
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 In article wrote: 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 | *** I'm trying a new usenet client for Mac, Nemo OS X. You can download it at http://www.malcom-mac.com/nemo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat column in all sheets | Excel Discussion (Misc queries) | |||
Repeat column headings | Excel Discussion (Misc queries) | |||
Cannot repeat column headings | Excel Discussion (Misc queries) | |||
How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
in excel can one repeat the text from a the last used column cell. | Excel Discussion (Misc queries) |