Help with excel formula... Please
 

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

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

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

Thanks Bob. That goes in my HowTo file. Otto
"Bob Phillips" wrote in message
...
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

Thank you for the help!

"Otto Moehrbach" wrote:

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

Thank you for the help!

"Bob Phillips" wrote:

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