software

I am trying to have the last value entered in a column to display at the
bottom of the column. Each column is updated daily and I want it to always
take the last value in the column.

Thank You

Marc,

For example, in cell D101, enter:

=INDEX(D1100,COUNTA(D1100))

This assumes that there are no intermediate blanks in range D1100 - i.e., cell D59 is blank but
cells D60, D61, and on are filled. If that is the case (intermediate blanks are there) then this
array formula, entered with Ctrl-Shift-Enter, will do it:

=INDEX(D1100,MAX((D1100lt;gt;quot;quot;)*ROW(D1100)))

HTH,
Bernie
MS Excel MVPquot;Marcquot; gt; wrote in message
...
gt;I am trying to have the last value entered in a column to display at the
gt; bottom of the column. Each column is updated daily and I want it to always
gt; take the last value in the column.
gt;
gt; Thank You