Hi!
I'm looking for a formula that would give me the row number of the second or next non-blank cell in a column, based on an input value in another cell.
Basically, what I'm looking for is a formula that will return the row number of the next non-empty cell that is greater than the reference value in cell E1. In this case it would be the row containing 181 = 8. If I were to input 200 in E1, the formula would return the row containing 273 = 11, etc.
excel.PNG
I've already managed to find the first non-empty cell containing the first value lower than cell E1 with the MATCH formula using MATCH TYPE=1, but I can't use MATCH TYPE=-1 because the list would have to be sorted in a descending order, which would render the previous formula useless.
Thanks!
Bookmarks