Fill blank cells with an if formula?

G

Gaby

i have a column with blanks cells and i want to fill them with the last cell
with a value...how can i do that?
 
R

Ron Coderre

If you have something like this:

Value
Value
(Blank)
(Blank)
Value
(Blank)
Value

and you want to have each blank cell display that last value above it...
try this:

Select the range of values and blanks

Press the [F5] key.......a shortcut for <edit><go to>
Click the [special] button.....Check: Blanks......Click [OK]

While the blank cells are selected
Press [F2]....Type: =.....Press the UP arrow one time...
Hold down the [Ctrl] key and press [Enter]

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Top