Using the last number?

[BottleBoy]

Hello All,
I am making a basic Weight tracking Spreadsheet and was wondering if there is a way that I could set the current weight to be the last weight I put in.

I.E.
Sept1 90.0kg
Sept2 89.5kg
Sept3 89.0kg ...... etc etc .

I want the last inpurt to be read to another cell as to claculate my progress

Cheers

 

[Aladin Akyurek]

Hello All,
I am making a basic Weight tracking Spreadsheet and was wondering if there is a way that I could set the current weight to be the last weight I put in.

I.E.
Sept1 90.0kg
Sept2 89.5kg
Sept3 89.0kg ...... etc etc .

I want the last inpurt to be read to another cell as to claculate my progress

Cheers

=LOOKUP(REPT("z",255),WeightRange)

If weights are true numbers...

=LOOKUP(9.99999999999999E+307,WeightRange)