copy cell value

I

itsmemike

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.
 
Y

yshridhar

=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
 
I

itsmemike

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.
 
Y

yshridhar

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Help needed 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
copy last populated cell (moving) to another cell 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
#VALUE 2
Need macro to move to first blank cell in column 6
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Top