If function
 

I have columns of data that are imported from a text file.

I need to create rows of information based on rows above. I can get it to
work using the following IF function: =IF(ISBLANK(A2),A1,A2). However, if a
subsequent row is blank the formula returns a 0. How do get it to use the
formula result from the row above?

An example of what I get is shown below:
A B
Name
John Doe John Doe
John Doe
0
Jane Smith Jane Smith
Ben Gay Ben Gay
Col Gate Col Gate
Arthur Itis Arthur Itis

If function
 

try instead
=if(ISBLANK(A2),B1,A2)

"Lost in Microbiology" wrote:

I have columns of data that are imported from a text file.

I need to create rows of information based on rows above. I can get it to
work using the following IF function: =IF(ISBLANK(A2),A1,A2). However, if a
subsequent row is blank the formula returns a 0. How do get it to use the
formula result from the row above?

An example of what I get is shown below:
A B
Name
John Doe John Doe
John Doe
0
Jane Smith Jane Smith
Ben Gay Ben Gay
Col Gate Col Gate
Arthur Itis Arthur Itis