Conditional If Statement

  • Thread starter Thread starter Moz
  • Start date Start date
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
 
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can i set a cell to alarm if a date isnt enterd before a set date 4
Comparing Dates in 4 Columns - Nested Formulas? 2
Using dates in IF statements 3
Average is dependent on conditions 3
IF Function 6
Nested IF Statement Help 4
if conditional formula required 13
IF statement and Network days 2

Back
Top