formula to return most recent entry

[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

 

[Anon]

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

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.

 

[donny]

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?

 

[Jason Morin]

=OFFSET(A1,MAX(IF(A1:A1000<>"",ROW(A1:A1000)))-1,)

Array-entered.

HTH
Jason
Atlanta, GA

 

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,A:A)

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

 

[donny]

I get a REF#! error.

-----Original Message-----
=OFFSET(A1,MAX(IF(A1:A1000<>"",ROW(A1:A1000)))-1,)

Array-entered.

HTH
Jason
Atlanta, GA

.