formula to return most recent entry

  • Thread starter Thread starter donny
  • Start date Start date
D

donny

I'm trying to figure out how to create a formula that will
return the most recent entry in a column for example:

A

1258
1100
1000
988

I would like the formula to return 988, note: additional
entries will be made on a daily basis to referencing a
range would not be accurate. Thanks for any help
 
donny said:
I'm trying to figure out how to create a formula that will
return the most recent entry in a column for example:

A

1258
1100
1000
988

I would like the formula to return 988, note: additional
entries will be made on a daily basis to referencing a
range would not be accurate. Thanks for any help
Click to expand...

Assuming the numbers start in A1 and are added sequentially to A2, A3, A4
and so on,
=OFFSET(A1,COUNT(A:A)-1,0)
will return the last one.

COUNT(A:A) simply counts how many numbers there are in column A.
Suppose there were 4. The OFFSET function then looks 4-1 (that is, 3) cells
down from A1 to get the last one.

The formula can be modified if necessary if the numbers start elsewhere, or
if the entries are not all numbers, or whatever.
 
I'm sorry, I forgot to add that cells below the values
have space values, can the formula be modified to only
bring forward whole values or real numbers?
 
=OFFSET(A1,MAX(IF(A1:A1000<>"",ROW(A1:A1000)))-1,)

Array-entered.

HTH
Jason
Atlanta, GA
 
=LOOKUP(9.99999999999999E+307,A:A)

You can replace A:A with a definite range if appropriate.
 
Back
Top