Excel Help

[jshonuff]

Need help with this.
Trying to get the cell to display in C column


A1 is 5 B1 is John how do I display C1-C5 to display John

Also if I change A1 to 2 it will Change C1-C2 to john with C3-C5 being empty?

 

[jshonuff]

What I was looking for is more like this

if
A1 is 5 B1 is John how do I get C1-C5 to display John

So if I change A1 to 2 it will Change C1-C2 to john with C3-C5 being empty.

f I change A1 to 3 it will Change C1-C3 to john with C4-C5 being empty.

socell A1 is the number I want cell b1 to display in column C

 

[wudixin96]

C1=IF(ROW()>$A$1,"",$B$1),
then filldown the formula from C1 to C1000(a large range)

 

[wudixin96]

see the attached file