Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using the last number in a column
Is there a way to use the last number in a column (in a formula) when you
won't know what the exact cell is where that number will be located? The last number will not be in a constant cell, this column is a running balance column so additonal rows will be added daily. Thanks for your help! |
#2
|
|||
|
|||
Using the last number in a column
One way
=INDEX(A1:A10000,COUNT(A1:A10000)) I am assuming here that there are no blanks, replace A1 with the cell the holds the first number and A10000 with a large enough number you'll know you won't go beyond If there are blanks you can use =LOOKUP(2,1/(A1:A10000<""),A1:A10000) -- Regards, Peo Sjoblom "MarkT" wrote in message ... Is there a way to use the last number in a column (in a formula) when you won't know what the exact cell is where that number will be located? The last number will not be in a constant cell, this column is a running balance column so additonal rows will be added daily. Thanks for your help! |
#3
|
|||
|
|||
Using the last number in a column
Thanks Peo,
That worked perfect! "Peo Sjoblom" wrote: One way =INDEX(A1:A10000,COUNT(A1:A10000)) I am assuming here that there are no blanks, replace A1 with the cell the holds the first number and A10000 with a large enough number you'll know you won't go beyond If there are blanks you can use =LOOKUP(2,1/(A1:A10000<""),A1:A10000) -- Regards, Peo Sjoblom "MarkT" wrote in message ... Is there a way to use the last number in a column (in a formula) when you won't know what the exact cell is where that number will be located? The last number will not be in a constant cell, this column is a running balance column so additonal rows will be added daily. Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
look up number in column | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
need column with 00:00:00 like stopwatch x's a number donemonthly | Excel Discussion (Misc queries) | |||
How do I sort a column a unique number? | Excel Worksheet Functions | |||
Number of Column Limitations | Excel Discussion (Misc queries) |