Get Value of Last Non-empty Cell in a Column in Spreadsheets

Let’s say you have a spreadsheet with dynamically growing row numbers. This is a simple formula to get the last non-empty cell in a column.

Microsoft Excel & LibreOffice Calc: 

=LOOKUP(2, 1 / (A:A <> “”), A:A)

Google Sheets: 

=ArrayFormula(LOOKUP(2, 1 / (A:A <> “”), A:A))

=INDEX(FILTER(A:A,NOT(ISBLANK(A:A))),ROWS(FILTER(A:A,NOT(ISBLANK(A:A)))))

Apple Numbers: 

=XLOOKUP(REGEX(“.”), A, A, “”, 2, −1)

In this instance, you want the last value in column A.