I've come across plenty of formulas to find blank cells within a certain specified range, but can't seem to figure this out / find an answer.
I have a spreadsheet kind of like this:
Where column A is empty except for these header bars, and there are lots of sections going down the sheet with these header bars.
What I'm trying to do is have a formula that can find the row of the cell A header from within a section, but so that the formula will work in any section.
So in the above "sheet", let's say I was in cell B52. Maybe there's a formula to look at A52, and if empty keep moving up until it found that cell A48 was the first cell upwards to have a value, and return the value as 48 (the row).
I'm also hoping this can be done with regular formulas and avoid using gss if possible so it can remain dynamic.
Any thoughts? Thanks!!
apparently not quite clear enough. I made another sheet to help illustrate further what the data looks like and what I'm after:
I'm hoping for a formula that when placed in cell B32 as highlighted, it will return A28, or just 28, as in the row of the previous non-blank cell, but then ideally, the same formula could then be placed anywhere else, say for example B46, which would then return A37 as the previous non-blank cell in the A column.