Finding Latest Variable

K

Ken

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

Trevor Shuttleworth

Ken

maybe:

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

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Copy & paste 1
Excel 2003 formula 2
Help with time formula 12
Random time? 5
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Counting Problem 2
Change cell font color if time is> by 15 minute intervals upto 2h 2

Top