If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
need a formula
Is there a formula that can return the last non-zero number in a column of
numbers? I have a column of numbers that I add to daily, and I need to know the value of the last number in that column for use in another formula. Thanks! -- Bill |
#2
|
|||
|
|||
need a formula
The following formula will return the last non-zero number in cells
A1:A20 -- =INDEX(A:A,MAX((A1:A200)*ROW(INDIRECT("1:20")))) It's an array formula -- type the formula in the cell, then hold the Ctrl + Shift keys, and press the Enter key. Bill H. wrote: Is there a formula that can return the last non-zero number in a column of numbers? I have a column of numbers that I add to daily, and I need to know the value of the last number in that column for use in another formula. Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
need a formula
thanks!
"Debra Dalgleish" wrote in message ... The following formula will return the last non-zero number in cells A1:A20 -- =INDEX(A:A,MAX((A1:A200)*ROW(INDIRECT("1:20")))) It's an array formula -- type the formula in the cell, then hold the Ctrl + Shift keys, and press the Enter key. Bill H. wrote: Is there a formula that can return the last non-zero number in a column of numbers? I have a column of numbers that I add to daily, and I need to know the value of the last number in that column for use in another formula. Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|