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

or

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

Diamonelle wrote:
I have a bank statement in Excel, I want Excel to look in a specific
colum and return the last number of that column. For Exemple, let's
say I have values in Column C and values from cell C8 to C55, I want
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