Excel Function / Formula To Show Last Value In a Column

If you want to show the last value of the Excel sheet column, here is a formula for you.

=LOOKUP(2,1/(B:B<>""),B:B)

If you want to reference another sheet, you can use it.
=LOOKUP(2,1/(Bank!E:E<>""),Bank!E:E)
Bank in this formula is the name of the sheet, which you want to reference.