Formula to lookup last number in colum

  • Thread starter Thread starter Diamonelle
  • Start date Start date
D

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
 
=LOOKUP(9.99999999999999E+307,C8:C65536)

or

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