| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional If Statement
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional If Statement
Select the range of cells.
F5SpecialBlanksOK 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 On Sat, 1 Dec 2007 07:56:01 -0800, Moz wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional If Statement
Nice!!! Thank You
"Gord Dibben" wrote: Select the range of cells. F5SpecialBlanksOK 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 On Sat, 1 Dec 2007 07:56:01 -0800, Moz wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Statement | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Conditional If statement | Excel Worksheet Functions | |||
| conditional statement | New Users to Excel | |||
| Conditional if statement | Excel Worksheet Functions | |||
Linear Mode
