Fill in Blank Cells

[maliti2008]

I have a column of Names that that has some empty fields. I need to complete that data, by filling the blank cells with the last non-balnk cell prior to that cell.

For example, Cell b5 has a name in it and the 5 cells below it are empty. i want to fill those empty cells by the value of cell b5 and start that process over and over

the blank cells dont have a set number in between.

Thoughts?

 

[sandy666]

Better to press the "=" button followed by pressing the "up" arrow... more generic

Btw, if not using the "up" arrow then the formula should have been changed to reference a cell in column B as that is the column the OP is dealing with

whatever you say