| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy selected part number of text from one cell into another cell | Excel Discussion (Misc queries) | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Linear Mode
