I have a spreadsheet I'm working on that we use to run large corporate events. Each segment length has a length as well as corresponding start time. I want each cell in the time column to look above itself and find the previous time and then add it to that segments length.
In column A it has the start time of that segment. Then, in column B, it has the segment length. So for example,
A1: start time &
B1: segment length. I then want
D2 (whichever is next) to go up and look for
A1 and add it to
The problem is that there are often blank rows in between so even though they are blank, it returns an error with the offset function statically moving 1 row at a time.
I can provide a screen shot if that helps. But, in short, I'm trying to dynamically find the cell above a given cell with content in it knowing that there could be may blank rows in between and not wanting them to calculate.