One way:

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

Biff

"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.