Complete Missing Row Data based on Row above

Hi I have a imported a text file into Excel which has worked well.

However, it consists of the employees name in row A3, and then data related to the same employee in B3 - B6.
The next employee's name is on A7, and then data related to this employees is on B7 -B12.

The number of rows of data per employee will vary.

I am trying to fill the rows in column A with the name of the employee that the data relates to. so for the first employee their name will be shown in A3 : A6, and for the second their name will show in A7 : A12

Can anyone suggest a formula where excel can see the cell is blank, and look back up the list to the find the last populated cell and use that to populate the current cell. helper columns in the spreadsheet are fine.

Any thoughts would be very much appreciated.

Sam

> Can anyone suggest a formula where excel can see the cell is blank, and look back up the list to the find the last populated cell and use that to populate the current cell.
This will do it for you
Insert a new col A
Put in A3: =B3 (assume data begins in row 3 down, which is as per your descript)
Put in A4: =IF(B4="",A3,B4)
Copy A4 down as far as required
---------------------------------------------------------
Success? Wave it, click on the little star at the bottom left of my responses

hope the attachment can be seen

sample.xls

Hi Max, thanks for replying but that only works for the first or second row of data. I have now attached a sample file which may make it clearer

Sam

Seems to work ok for me .. Try it again?
1. Insert 3 new cols A, B, C (as you have 3 cols to fill down from above)
2. Put in A3: =D3
Copy A3 across to C3
3. Put in A4: =IF(D4="",A3,D4)
Copy A4 across to C4, then select A4:C4 and fill down as far as required
---------------------------------------------------------
Success at last? Wave it, click on the little star at the bottom left of my responses