Help with problem finding first positive value in a cashflow

[davidran]

Hi

I have a problem trying to find which month a cummulative cashflow becomes positive. I have two rows the top one is month and goes from 1 to 36. The row below is the cummulative cashflow. The cashflow starts off negative and continues to become increasingly negative until month 21 or so when revenue coming in starts to decrease the deficit until the cashflow finally becomes positive.

I've tried using the INDEX function coupled with the MATCH function but unfortunately the MATCH function will only find the first positive value if the cashflow is sorted first into a descending order by value which I don't want to do.

Does anyone have any advice or guidance?

Thank you.

[AlKey]

Maybe using INDEX and MATCH(MIN(

[Moo the Dog]

How about this ARRAY formula, entered with Ctrl + Shift + Enter, instead of just Enter:

Please Login or Register  to view this content.

* Assumes your months are in A1:AJ1, and cumulative values are in A2:AJ2

- Moo

[davidran]

Hi Thank you Moo - thats awesome!

[Moo the Dog]

Glad to help, davidran.

Feel free to click on the small star at the lower-left corner of one of my posts to add to my reputation here on the boards.

- Moo

[davidran]

Done. Thanks again!