Thanks, it is exactly what I want. Weird though - and interestingly slightly
different from the other replies, which presumably also work.

I suppose I substitute 1:1 etc for last non-blank cell in a row.

H

"Pete_UK" wrote in message
...
This will give you the last numeric value that is not blank:

=LOOKUP(10E10,A:A)

Is that what you want?

Pete

On Mar 25, 1:48 pm, "Lawman" wrote:
In an expression, how do I refer to the last cell in a specified column
that
is not blank?

Thanks in advance.

H