Formula to populate following cells based on previous cells

[randrze2]

Hello, I am trying to figure out a formula that will help me populate cells based on the sample instance below. I've tried different IF statements but can't seems to get it to work right. Any help is greatly appreciated. Thanks!


[TABLE="width: 500"]
<tbody>[TR]
[TD]Name (current)
[/TD]
[TD]Name Populated All the Way down (formula)[/TD]
[/TR]
[TR]
[TD]Rob[/TD]
[TD]Rob[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Rob[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Rob[/TD]
[/TR]
[TR]
[TD]Jeff[/TD]
[TD]Jeff[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jeff[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]Steve[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Steve[/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

in B1 =A1

in B2 =if(a2="",B1,a2)

drag down

 

[Special-K99]

Use 2 columns A and B
With names and blanks in column B do the following

in B1
=A1
in B2
=IF(A2="",B1,A2)
and copy down column B

 

[gaz_chops]

Try
In cell B1
Enter =A1
In cell B2
Enter =if(A2="",B1,A2)

 

[oldbrewer]

threes a crowd...........