software

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.

Last numeric value=LOOKUP(9.99999999999999E307,A:A)Last text value=INDEX(A:A,MATCH(REPT(quot;Zquot;,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)

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