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