Conditional If Statement

M

Moz

I need to know the easiest way to tell excel if the Cells are blank than copy
the cell directy above it, if the cell is not blank go to the next row and
repeat.

RO NO BOOKED. CLOSED. DT TECH. LN SEQ M HT
1883 7-Nov-07 7-Nov-07 S1 61 B 2 OT
ST
1883 7-Nov-07 7-Nov-07 S1 61 C 3 ST
 
G

Gord Dibben

Select the range of cells.

F5>Special>Blanks>OK

Enter an = sign in the active blank cell then arrow or point to non-blank cell
above.

Hit CTRL + ENTER keys.

This will fill in the blanks with a formula pointing to the cell above.


Gord Dibben MS Excel MVP
 
M

Moz

Nice!!! Thank You

Gord Dibben said:
Select the range of cells.

F5>Special>Blanks>OK

Enter an = sign in the active blank cell then arrow or point to non-blank cell
above.

Hit CTRL + ENTER keys.

This will fill in the blanks with a formula pointing to the cell above.


Gord Dibben MS Excel MVP
Click to expand...
 
Top