Formula to lookup last number in colum

[Diamonelle]

I have a bank statement in Excel, I want Excel to look in a specifi
colum and return the last number of that column. For Exemple, let'
say I have values in Column C and values from cell C8 to C55, I wan
the value in cell C55 to be returned to me in a specific cell!

I hope my explanation is easy to understand! Hope someone can help.

Thanks!

Maggy :confused

 

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,C8:C65536)

or

=LOOKUP(9.99999999999999E+307,C8:C55)