Finding last non-blank cell in a column

  • Thread starter Microsoft.news.com
  • Start date
M

Microsoft.news.com

I am trying to create a cell at the top of a worksheet that will give me the
last non-blank cell in a column. The column is a list of dates.

Any help is much appreciated.

Bob Weeden
 
B

Bob Phillips

=INDEX(A:A,MAX(IF(ISNUMBER(A1:A65535),ROW(A1:A65535))))

as an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

Dave Peterson

In A1 (with no gaps in column G):
=index(g:g,counta(g:g))

=Counta() counts formulas, too--including those that make the cell look blank
(by returning "").

Is that a problem?
 
G

Gord Dibben

=ADDRESS(MATCH(9.99999999999999E+307,A:A),1) address of last value in column

=LOOKUP(9.99999999999999E+307,A:A) will fetch the last value in column

Note: values must be numeric(dates are)


Gord Dibben Excel MVP
 
Top