Hi,
I am looking for a formula to look in a cell say A1 and return that value to B1, moving down to say A2 if the that cell is blank then look in cell above A1) and return that value to B2. and so on. (See the sample attachment for the type of result I am looking for).
Any help appreciated.
Bookmarks