Auto-copy the last entry in a column to a new cell

[George F]

I want to auto-copy the last calculated result in a column, to a specific
cell. The column can be any length but not all cells in the column will
contain data, I only want the last result.

[Biff]

Hi!

>I want to auto-copy the last calculated result in a column

Does "calculated" mean that it's a numeric value?

With the column in question being column A, try this:

=LOOKUP(9.99999999999999E+307,A:A)

Biff

"George F" <George F@discussions.microsoft.com> wrote in message
news:DC54240E-7DA1-4F0B-835D-C6E7CFB315AE@microsoft.com...
>I want to auto-copy the last calculated result in a column, to a specific
> cell. The column can be any length but not all cells in the column will
> contain data, I only want the last result.
>
>

[GerryK]

=OFFSET(A1,MAX(IF(A1:A1000<>"",ROW(A1:A1000)))-1,)
array entered (Ctrl+Shift+Enter) in the cell you want.

Modify A1000 to suit your needs or A.

HTH
GerryK


"George F" wrote:

> I want to auto-copy the last calculated result in a column, to a specific
> cell. The column can be any length but not all cells in the column will
> contain data, I only want the last result.
>
>