Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with excel formula... Please
I want to take the LAST cell of column A (which will be changing with
entries) and paste it into a fixed cell in column B. Thanks |
#2
|
|||
|
|||
The formula:
=OFFSET(A1,COUNT(A2:A1000),0) in any cell will result in the value of the last occupied cell in Column A. Note that cell A2 must be occupied. HTH Otto "ventimaj" wrote in message ... I want to take the LAST cell of column A (which will be changing with entries) and paste it into a fixed cell in column B. Thanks |
#3
|
|||
|
|||
Otto's formula will work for numbers in column A, where there are no
embedded blank cells. To cater for blanks, numbers or text, try =LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535) -- HTH Bob Phillips "Otto Moehrbach" wrote in message ... The formula: =OFFSET(A1,COUNT(A2:A1000),0) in any cell will result in the value of the last occupied cell in Column A. Note that cell A2 must be occupied. HTH Otto "ventimaj" wrote in message ... I want to take the LAST cell of column A (which will be changing with entries) and paste it into a fixed cell in column B. Thanks |
#4
|
|||
|
|||
Thanks Bob. That goes in my HowTo file. Otto
"Bob Phillips" wrote in message ... Otto's formula will work for numbers in column A, where there are no embedded blank cells. To cater for blanks, numbers or text, try =LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535) -- HTH Bob Phillips "Otto Moehrbach" wrote in message ... The formula: =OFFSET(A1,COUNT(A2:A1000),0) in any cell will result in the value of the last occupied cell in Column A. Note that cell A2 must be occupied. HTH Otto "ventimaj" wrote in message ... I want to take the LAST cell of column A (which will be changing with entries) and paste it into a fixed cell in column B. Thanks |
#5
|
|||
|
|||
Thank you for the help!
"Otto Moehrbach" wrote: The formula: =OFFSET(A1,COUNT(A2:A1000),0) in any cell will result in the value of the last occupied cell in Column A. Note that cell A2 must be occupied. HTH Otto "ventimaj" wrote in message ... I want to take the LAST cell of column A (which will be changing with entries) and paste it into a fixed cell in column B. Thanks |
#6
|
|||
|
|||
Thank you for the help!
"Bob Phillips" wrote: Otto's formula will work for numbers in column A, where there are no embedded blank cells. To cater for blanks, numbers or text, try =LOOKUP(2,1/(1-ISBLANK(A1:A65535)),A1:A65535) -- HTH Bob Phillips "Otto Moehrbach" wrote in message ... The formula: =OFFSET(A1,COUNT(A2:A1000),0) in any cell will result in the value of the last occupied cell in Column A. Note that cell A2 must be occupied. HTH Otto "ventimaj" wrote in message ... I want to take the LAST cell of column A (which will be changing with entries) and paste it into a fixed cell in column B. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |