If there are no blanks

=INDEX(A:A,COUNT(A:A))

if there are blanks

=LOOKUP(2,1/(A1:A1000<""),A1:A1000)


--

Regards,

Peo Sjoblom


"billandrus" wrote
in message ...

How do I get the last entry in a fixed column? For example:

The column is 10 rows.

Row 1 is the number 25
Row 2 is 30
The rest are blanks.

What is the function to pick the latest entry that being 30.

Then when row 3 changes to 45 then the "choose" function would select
the latest entry that now being 45.

Thanks

Bill Andrus


--
billandrus
------------------------------------------------------------------------
billandrus's Profile:
http://www.excelforum.com/member.php...o&userid=27945
View this thread: http://www.excelforum.com/showthread...hreadid=478927