Howdy folks! I can't figure this out so hope someone here can help!
Spreadsheet0.jpg
The first table is what I have now - column B depends upon the result of column C and 1 row above...
The second table is what I'm having trouble with - how do I adjust the formula so that it still works, even when there are gaps in the column of different sizes?
How do I create a formula that keeps looking upwards along the column, until it hits a non-blank cell?
Thank you!
Bookmarks