MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
If I have a chart in excel with a couple of trend lines extended, is there a way I can get excel to tell me where they intersect?
Thinking aloud, if you get it to tell you the equations of the trend lines, can you not solve for X? Or put the two equations into the sheet and use Goalseek to do the solving for X - plug X back into either equ and have a coordinate (plug into other equation as well to confirm you have the correct intersect if the equations may predict multiple intersepts).
as bristol says you can take the trend equations and solve for X.
use goalseek if you dont want to do it with algebra.
cheers.
got the trend equations, and using vlookup on the ratio of results to find 1
you can show equation of a trend line