Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy the last cell in an Excel column to another cell
I am a novice excel user. I have a spread sheet that continually changes,
rows and columns add or subtract up to a total. The total column contiunues to grow in length as new entries are made. Can this last cell with an entry be copied to another cell, for example in a header back at the top of the spread sheet? I have tried to find a function to no avail...MAX wont work becasue the number can get smaller. Thanks in advance. |
#2
|
|||
|
|||
Assuming that Column C contains the 'Total', try...
=LOOKUP(9.99999999999999E+307,C:C) Hope this helps! In article , bob wrote: I am a novice excel user. I have a spread sheet that continually changes, rows and columns add or subtract up to a total. The total column contiunues to grow in length as new entries are made. Can this last cell with an entry be copied to another cell, for example in a header back at the top of the spread sheet? I have tried to find a function to no avail...MAX wont work becasue the number can get smaller. Thanks in advance. |
#3
|
|||
|
|||
For example to get the last cell in column A use:
=LOOKUP(2,1/(A2:A653560),A2:A65356) Started with A2 because A1 had a label -- Gary''s Student "bob" wrote: I am a novice excel user. I have a spread sheet that continually changes, rows and columns add or subtract up to a total. The total column contiunues to grow in length as new entries are made. Can this last cell with an entry be copied to another cell, for example in a header back at the top of the spread sheet? I have tried to find a function to no avail...MAX wont work becasue the number can get smaller. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Format Control: 'cell link' reamins constant. How to copy | Excel Worksheet Functions | |||
How can I copy Word data into a merged cell in Excel? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions |