| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for last cell
I need a formula that will show the last cell in a range.
1000 2000 3000 want to show 3000 as the result and not the total of everything in the column!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula for last cell
For numeric values try
=LOOKUP(9.99999999999999E+307,A:A) Change the column to suit Mike "gwbdirect" wrote: I need a formula that will show the last cell in a range. 1000 2000 3000 want to show 3000 as the result and not the total of everything in the column!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula for last cell
Check out this link...
http://www.xldynamic.com/source/xld.LastValue.html -- HTH... Jim Thomlinson "gwbdirect" wrote: I need a formula that will show the last cell in a range. 1000 2000 3000 want to show 3000 as the result and not the total of everything in the column!!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula for last cell
This appears to return the contents of the last cell in a specified column
whether that cell holds a number or text... =LOOKUP(2,1/(A1:A65535<""),A:A) Rick "gwbdirect" wrote in message ... I need a formula that will show the last cell in a range. 1000 2000 3000 want to show 3000 as the result and not the total of everything in the column!!! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula for last cell
Thanks jim I will check it out.
"Jim Thomlinson" wrote: Check out this link... http://www.xldynamic.com/source/xld.LastValue.html -- HTH... Jim Thomlinson "gwbdirect" wrote: I need a formula that will show the last cell in a range. 1000 2000 3000 want to show 3000 as the result and not the total of everything in the column!!! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula for last cell
thanks for your help. I will try this formula.
"Mike H" wrote: For numeric values try =LOOKUP(9.99999999999999E+307,A:A) Change the column to suit Mike "gwbdirect" wrote: I need a formula that will show the last cell in a range. 1000 2000 3000 want to show 3000 as the result and not the total of everything in the column!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract cell formula from existing cell formula | Excel Programming | |||
| get the value of a formula in cell B1 into cell A1 without changing my current cell selection | Excel Programming | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Linear Mode
