| 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 |
| 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 | |||
Threaded Mode
