Populating a range of cell, based on 2 values

[philef]

I have searched old threads but came up empty, so I am putting up my query here. I need to populate a range of cells, e.g., from C1 to Cx, based on the values of cells A1 and B1.

For example, A1 = "John Doe" (it will be the name of a person); and B1 = 12. I would like to have "John Doe" copied 12 times, from C1 to C12.

Thank you for your help.

[AlKey]

Try this
Enter formula in C1 and copy down

Please Login or Register  to view this content.

v	A	B	C
1	John Doe	12	John Doe
2	John J Deer		John Doe
3			John Doe
4			John Doe
5			John Doe
6			John Doe
7			John Doe
8			John Doe
9			John Doe
10			John Doe
11			John Doe
12			John Doe
13			John J Deer
14			John J Deer
15			John J Deer
16			John J Deer
17			John J Deer
18			John J Deer
19			John J Deer
20			John J Deer
21			John J Deer
22			John J Deer
23			John J Deer
24			John J Deer
25

[TMS]

Please Login or Register  to view this content.

Or just

Please Login or Register  to view this content.

[philef]

Thank you very much, I knew there was a way to do it. Now I just need to bone up on the functions you used. Gracias!

[Palmetto]

One of the most useful but, probably, under utilized tools in Excel is the Evaluate Formula Tool.
Using it will help you see how Excel evaluates each argument in a function.

Select the cell with the formula then go to the Ribbon Menu > Formulas > Evaluate Formula to activate the tool.
While this tool is very useful, one must understand the required arguments in the formula syntax to make full sense of the results observed when using it.

[philef]

I didn't even know that that feature (Evaluate Formula) existed... Thanks!