Posted to microsoft.public.excel.worksheet.functions
|
|
Auto-copy the last entry in a column to a new cell
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 wrote in message
...
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.
|