What function can I use to find the first non-blank cell nearest the bottom of a column and display that value in the bottom row?

What function can I use to find the first non-blank cell from the bottom up in a column and display that value in the bottom row?