Return the Last Numeric Value in a Column

Returning the final value in a column is particularly useful for spreadsheets that involve running balances, where you want to reference the final balance regardless of whether it is the smallest or largest value in the column.After trying a variety of different formulas for returning the last numeric value in a column, I settled on the following two.=VLOOKUP(9.99999999999999E+307,A:A,1) or=