=INDIRECT("B"&MAX(IF(NOT(ISBLANK(B1:B10)),ROW(1:10 ))))
which is an array formula, so commit with Ctrl-Shift-Enter
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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