ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Finding Intersection Points between different lines (https://www.excelbanter.com/excel-programming/444734-finding-intersection-points-between-different-lines.html)

WizardGeophysicist

Finding Intersection Points between different lines
 
I have different line with points (each point has X/Y value). The
lines are intersecting in certain points. I need to output a list of
the intersecting point for each line.
The other issue is that I need to allow tolerance for the X/Y value,
let's say line 1 Point 1 XY value is 100000 and 300000 and it
intersects with line 2 Point 2 but the XY value is 100010 and 300010.
i.e. the they are not intersecting on the given points but between
points. I am spending a lot of time on this and I am getting nowhere.

I am attaching a sample for two lines. And I am highlighting the
intersection point of the two lines in yellow.

I do appreciate any help.

Thanks!
Karim

WizardGeophysicist

Finding Intersection Points between different lines
 
Here's the sample:
http://www.2shared.com/document/jU6y-ts_/sample.html


All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com