Otto's formula will work for numbers in column A, where there are no
embedded blank cells. To cater for blanks, numbers or text, try
=LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535)
--
HTH
Bob Phillips
"Otto Moehrbach" wrote in message
...
The formula:
=OFFSET(A1,COUNT(A2:A1000),0)
in any cell will result in the value of the last occupied cell in Column
A.
Note that cell A2 must be occupied. HTH Otto
"ventimaj" wrote in message
...
I want to take the LAST cell of column A (which will be changing with
entries) and paste it into a fixed cell in column B.
Thanks
|