Finding Latest Variable

[Guest]

Assume cells A1 to A20 are filled in one at a time with values every 5
minutes. A1 will have a value after 5 minutes, A2 will have a value after 10
minutes, A3 after 15 minutes etc ... I would like cell A21 to indicate the
most recent added value. For example, after 12 minutes I would like A21 to
equal A2, after 17 minutes equal to A3 etc ... What formula do I place in
cell A21 to do this?

 

[Trevor Shuttleworth]

Ken

maybe:

=IF(ISERROR(INDEX(A1:A20,COUNTA(A1:A20))),"",INDEX(A1:A20,COUNTA(A1:A20)))

Regards

Trevor