If function

  • Thread starter Lost in Microbiology
  • Start date
L

Lost in Microbiology

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique Value Count in 3 Columns Using Search Criteria 0
Combine multiple columns and rows for one record into one row. 2
Combining rows with duplicate names - sum numeric, concatenate str 0
SUMIF & IF 5
Conditional Format Formula for finding duplicates in a row 1
Total using 2 columns for criteria 3
Reference a column to make groups 1
Counting with multiple criteria in separate Columns 4

Top