Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to Find First Cell in a Row with Values
Hello, I am trying to find the value in a series of cash flows that is
the first month to have a cash flow. I have the formula to find the max, which is =SUMPRODUCT((MAX(($a2:$z20)*($a$1:$z$1)))), (thank you Rick Rothstein!)where row 2 equals the cash flow and row 1 equals the corresponding date. I am now looking to find the first month with a number that is not zero. I tried switching the MAX to MIN and the switching the sign around. All I get is 0 when I do that. Any suggestions? Thanks again. Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to Find First Cell in a Row with Values
Try this array-entered** formula...
=(MIN(IF(($A2:$Z20),$A$1:$Z$1),99999)) **Commit this formula with Ctrl+Shift+Enter, not just Enter by itself. -- Rick (MVP - Excel) "cardan" wrote in message ... Hello, I am trying to find the value in a series of cash flows that is the first month to have a cash flow. I have the formula to find the max, which is =SUMPRODUCT((MAX(($a2:$z20)*($a$1:$z$1)))), (thank you Rick Rothstein!)where row 2 equals the cash flow and row 1 equals the corresponding date. I am now looking to find the first month with a number that is not zero. I tried switching the MAX to MIN and the switching the sign around. All I get is 0 when I do that. Any suggestions? Thanks again. Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to find cell values containing X | Excel Discussion (Misc queries) | |||
Formula to find greater of two values??? | Excel Discussion (Misc queries) | |||
UDF code to find specific text in cell comments, then average cell values | Excel Programming | |||
Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
Search/Filter to find values in another range based on two cell values | Excel Programming |