supes927
09-06-2010, 08:52 PM
I'm wondering if there is a way of using any excel/vba functions to predict where two sets of data will meet. I can't see a way to use Forecast for this.
EG:
Set 1 - 10,25,40,90 (Low values increasing)
Set 2 - 200,190,185,150 (Higher values decreasing)
After a certain amount of iterations if the trends are linear the values from Set 1 & Set 2 will correspond. Does Excel provide for this or will I have to brush up on my math?
EG:
Set 1 - 10,25,40,90 (Low values increasing)
Set 2 - 200,190,185,150 (Higher values decreasing)
After a certain amount of iterations if the trends are linear the values from Set 1 & Set 2 will correspond. Does Excel provide for this or will I have to brush up on my math?