Location of the Last cell in a column containing data
 

I need to find a formula to return the address of the last cell in a column
that contains data. The location will always change as more data is added to
the sheet.

Location of the Last cell in a column containing data
 

Last numeric value


=LOOKUP(9.99999999999999E307,A:A)


Last text value


=INDEX(A:A,MATCH(REPT("Z",255),A:A))


Last either


=INDEX(A:A,MAX(IF(ISBLANK(A1:A65535),0,ROW(A1:A655 35))))


which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Diggs" wrote in message
...
I need to find a formula to return the address of the last cell in a
column
that contains data. The location will always change as more data is added
to
the sheet.