Location of the Last cell in a column containing data

D

Diggs

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

Bob Phillips

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:A65535))))


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)
 
Top