copy cell value
 

How do i copy the last cell containing a value from a column to another blank
cell. I have entered a sum formula into the first cell and copied it down the
column but will not always fill all the cells, in a cell at the bottom of the
cell i want to show the last balance.

copy cell value
 

=LOOKUP(99^99,a:a)
It will return the last occupied cell in A-column
Place the formula in the cell you need.
best wishes
Sreedhar

"itsmemike" wrote:

How do i copy the last cell containing a value from a column to another blank
cell. I have entered a sum formula into the first cell and copied it down the
column but will not always fill all the cells, in a cell at the bottom of the
cell i want to show the last balance.

copy cell value
 

Thank you for your reply
I tried this but it returned a 0, I am working on a accounts sheet, the
cells above contains a formula which gives the total from say columns A,B,C.
at the bottom of D i want to show the last balance.
"yshridhar" wrote:

=LOOKUP(99^99,a:a)
It will return the last occupied cell in A-column
Place the formula in the cell you need.
best wishes
Sreedhar

"itsmemike" wrote:

How do i copy the last cell containing a value from a column to another blank
cell. I have entered a sum formula into the first cell and copied it down the
column but will not always fill all the cells, in a cell at the bottom of the
cell i want to show the last balance.

copy cell value
 

=LOOKUP(99^99,a:a)
The formula returns the value in the last cell of A-column (numeric)
Change the range according to your requirement.
If you want to sum the last occupied cell values in A,B,C columns
=LOOKUP(99^99,a:a)+LOOKUP(99^99,b:b)+LOOKUP(99^99, c:c)
Best wishes
Sreedhar
"itsmemike" wrote:


Thank you for your reply
I tried this but it returned a 0, I am working on a accounts sheet, the
cells above contains a formula which gives the total from say columns A,B,C.
at the bottom of D i want to show the last balance.
"yshridhar" wrote:

=LOOKUP(99^99,a:a)
It will return the last occupied cell in A-column
Place the formula in the cell you need.
best wishes
Sreedhar

"itsmemike" wrote:

How do i copy the last cell containing a value from a column to another blank
cell. I have entered a sum formula into the first cell and copied it down the
column but will not always fill all the cells, in a cell at the bottom of the
cell i want to show the last balance.