Find next to last value in column

[mrpaw]

Is there a way to find the next-to-last numeric value in a column? I can find the last using =LOOKUP(9.99999999999999+307,range), but then I need the last number before that one.

 

[Joe4]

Take a look at the "Find and return the second to last value in column B" section here: https://www.extendoffice.com/documents/excel/4138-excel-find-second-last-value-in-row-column.html