Search code examples
google-sheetscell

Google Sheets-Last Populated Cell in Column-Above Current Cell

In A,5 I have a numeric value, in A,15 I have a numeric value. There are blank gaps in the column. In A,10 I want to find the last populated cell in the A column, above the current cell, A,10. The result should return A,5.

I am completely stumped on how to accomplish this, any help will be greatly appreciated.

Solution

  • Does this formula work as you want in cell A10:

    =+sort(INDIRECT("A1:A"&ROW()-1),INDIRECT("A1:A"&ROW()-1)<>"",,row(INDIRECT("A1:A"&ROW()-1)),)