Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-copy the last entry in a column to a new cell
I want to auto-copy the last calculated result in a column, to a specific
cell. The column can be any length but not all cells in the column will contain data, I only want the last result. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-copy the last entry in a column to a new cell
Hi!
I want to auto-copy the last calculated result in a column Does "calculated" mean that it's a numeric value? With the column in question being column A, try this: =LOOKUP(9.99999999999999E+307,A:A) Biff "George F" <George wrote in message ... I want to auto-copy the last calculated result in a column, to a specific cell. The column can be any length but not all cells in the column will contain data, I only want the last result. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto-copy the last entry in a column to a new cell
=OFFSET(A1,MAX(IF(A1:A1000<"",ROW(A1:A1000)))-1,)
array entered (Ctrl+Shift+Enter) in the cell you want. Modify A1000 to suit your needs or A. HTH GerryK "George F" wrote: I want to auto-copy the last calculated result in a column, to a specific cell. The column can be any length but not all cells in the column will contain data, I only want the last result. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
HOW DO I COPY THE LAST NON BLANK CELL IN A COLUMN | Excel Worksheet Functions | |||
How to copy the url for a list of cell with hyperlinks in another column? | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions |