Harlan might say:
"Unneeded function call."

Or Aladin!

Yeah, but if the range is "small" it's a lot less confusing than
9.99999999999999E+307 or 99^99.

Biff

"RagDyeR" wrote in message
...
Harlan might say:
"Unneeded function call."
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Biff" wrote in message
...
Or even:

=LOOKUP(MAX(A:A)+1,A:A)

Biff

"RagDyer" wrote in message
...
OR ... something like:

=LOOKUP(99^99,A:A)

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"L. Howard Kittle" wrote in message
. ..
Hi Eric,

Just to add to Biff's solution, if you knew for absolute sure that the
largest number in the column of interest would never exceed 365, then
you
could use

=LOOKUP(366,A:A)

HTH
Regards,
Howard

"Eric" wrote in message
...
I've got a range where I'm including a bunch of values. I need a
formula
which will return the last value non-blank in the range. Not the
highest or
lowest, simply the last.

Thanks.