How do I find the last value of a column

S

sepdan

Is there a function that will return the last value of a column or return a
value for that cell?
 
D

daddylonglegs

To return the last numeric entry in column A

=LOOKUP(9.99999999999999E+307,A:A)
 
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