Auto-copy the last entry in a column to a new cell
=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.
|