So annoyed I can't find a simple answer to this simple question!
I'm using OpenOffice Calc. I want a formula which will detect if the cell is blank, and if it is to replace it with the contents in the cell above it.
I guess the best way to do this is create a new blank column, put formulae in there. Then copy the formula results and paste into original column as plain text.
Column A : Column B (formula column) Joe Joe Bloggs Bloggs Mack Mack Mack Mack Peter Peter John John John Joe Joe
Something like this:
Can't seem to get formulae to work and I only get an error (err:508 / err:509).