Help with excel formula... Please

V

ventimaj

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
 
O

Otto Moehrbach

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
 
B

Bob Phillips

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)
 
O

Otto Moehrbach

Thanks Bob. That goes in my HowTo file. Otto
Bob Phillips said:
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)
Click to expand...
 
V

ventimaj

Thank you for the help!

Otto Moehrbach said:
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
Click to expand...
 
V

ventimaj

Thank you for the help!

Bob Phillips said:
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)
Click to expand...
 
Top