Hello all, hope the best.
I have two set arrays that I want to find intersection point of them. One way is to fit a trendline and find the equation for each. then solve the equations and find the intersection. Problem is that everytime that any of those arrays changed a new trendline need to be fit and its equations solved to find the intersection.
I am wondering if there is any other method that can find the intersection which is autoupdated?
thanks.
I have two set arrays that I want to find intersection point of them. One way is to fit a trendline and find the equation for each. then solve the equations and find the intersection. Problem is that everytime that any of those arrays changed a new trendline need to be fit and its equations solved to find the intersection.
I am wondering if there is any other method that can find the intersection which is autoupdated?
thanks.