Finding Latest Variable
 

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?
--
Ken

Finding Latest Variable
 

Ken

maybe:

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

Regards

Trevor


"Ken" wrote in message
...
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?
--
Ken