Finding last non-blank cell in a column

[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

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

"Microsoft.news.com" <rweeden@wesd.k12.az.us> wrote in message
news:%23mwRL9O$FHA.1172@TK2MSFTNGP10.phx.gbl...
> 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
>
>

[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?


"Microsoft.news.com" wrote:
>
> 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

--

Dave Peterson

[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

On Fri, 9 Dec 2005 11:35:11 -0700, "Microsoft.news.com"
<rweeden@wesd.k12.az.us> wrote:

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