Finding a break even point in a series of data...

Brazilnut,

Please read the link about crossposting below. It explains why crossposting, without notification, is annoying and against this forum's rules.

When I got no feed-back about the array formula
=MATCH(0,--(SIGN(A1:A65000)=SIGN(A2:A65001)),0)

posted at http://www.mrexcel.com/forum/showthread.php?t=327730, I assumed that you found it sufficiant, but you were too busy completing your project to let us know that.
It seems that that was not the case.

If a suggestion doesn't work for you, posting that failure, along with how it fails you, encourages people to modify things until a solution is found.

If a suggestion works, posting that will help those who use the forums' search features.

When a questioner abandons a thread, it get them a reputation. And people will be less willing to help that questioner in the future.