excel; if cell empty copy from cell above?

  keef66 11:57 13 Sep 07

I'm working with the output from a database which ends up as an excel sheet.
At the moment it puts the details of where a record came from on the first line only, even if the result is multiple lines.

Is there a formula I can paste into all cells so that if a cell is empty it will display the contents of the cell above it?

  Noldi 12:04 13 Sep 07

click here
is this the type of thing you are looking for?.


  VoG II 12:39 13 Sep 07

Similar to Noldi's method:

Select the column of record numbers

Press F5

Click Special, tick Blanks, click OK

Type =

Press the Up arrow.

Press CTRL + Enter.

  keef66 13:46 13 Sep 07

thanks both; that's saved me several days work!

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac