Auto-copy the last entry in a column to a new cell
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. |
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. |
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. |
All times are GMT +1. The time now is 08:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com