Do you want the value or the address?

Addresses..............

=ADDRESS(MATCH(99^99,A:A),1) of last number

=LOOKUP(REPT("z",255),A:A) of last text entry


Gord Dibben MS Excel MVP

On Tue, 25 Mar 2008 14:17:20 -0000, "Lawman" wrote:

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