ExcelBanter - replace blanks using formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - replace blanks using formula (https://www.excelbanter.com/excel-worksheet-functions/79739-replace-blanks-using-formula.html)

susiecc60

replace blanks using formula

How do I replace blank cells with the number in the cell above it in the same
columns?

Max

replace blanks using formula

Try Debra Dalgleish's page for
some nice ideas on filling in the blank cells:
http://www.contextures.com/xlDataEntry02.html
Fill Blank Cells
Fill Blank Cells Programmatically
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susiecc60" wrote in message
...
How do I replace blank cells with the number in the cell above it in the
same
columns?

All times are GMT +1. The time now is 12:15 AM.