MrExcel Publishing
Your One Stop for Excel Tips & Solutions

filling in the blanks


Posted by mitch on February 01, 2002 4:08 PM

working with a file that I need to go down a coloum and fill in the blank cells from the cell above it.


Posted by Barrie Davidson on February 01, 2002 6:40 PM

How about using a formula in an adjacent column and then copying the formula's result (values only) over the existing data. Assuming your data is in column A, put =A1 in cell B1 and this formula in B2:

=IF(ISBLANK(A2),B1,A2)

Copy this formula down to the end. Then you can copy column B and paste values in column A.

Regards,
BarrieBarrie Davidson