In Excel 2007, in column A I have some cells that contain employee's names
and certain cells that don't. For instance, in A1 I have employee1, in cells
A2-A13 I have other stuff and in cell A14 I have employee2. In cell B1 i
have the following formula: =isnumber(match(A1,Employees,0)) and I have a
list with employee's names in it defined as "Employees". This is what I need
to do:

In cell C I would like to have only employee names. If the same row in
column A does not contain an employee then I would like to return the
employee above it. For instance, cell A13 does not contain an employee and
the closest employee above it is in cell A1 so in cell C13 I would like to
have "employee1". I can't seem to figure out how to do this. I would prefer
to do it without a macro if possible.

Thanks.