deusextra

08-02-2013, 03:31 AM

Hello forum,

I have the following problem:

I have a list of co-ordinates for the start and end point of various roads and what I need to know is which pairs of roads pass over the same co-ordinates at some point.

E.g.

Consider the following 4 road sections:

Road A: Start Point: 25000, End Point: 25200

Road B: Start Point: 25150, End Point: 25250

Road C: Start Point: 25140, End Point: 25340

Road D: Start Point: 25300, End Point: 25400

From these 4 given roads we can see that the following roads can be considered as pairs:

Road A & Road B

Road A & Road C

Road B & Road C

Road C & Road D

The problem is that I have thousands of road co-ordinates that I need to find the pairs for and manually this would take forever. I was hoping some VBA guru out there would be able to find an automated process for finding the pairs.

I have posted an excel sample file below that you can work off if you find this easier.

Any suggestions would be greatly appreciated!

10357

I have the following problem:

I have a list of co-ordinates for the start and end point of various roads and what I need to know is which pairs of roads pass over the same co-ordinates at some point.

E.g.

Consider the following 4 road sections:

Road A: Start Point: 25000, End Point: 25200

Road B: Start Point: 25150, End Point: 25250

Road C: Start Point: 25140, End Point: 25340

Road D: Start Point: 25300, End Point: 25400

From these 4 given roads we can see that the following roads can be considered as pairs:

Road A & Road B

Road A & Road C

Road B & Road C

Road C & Road D

The problem is that I have thousands of road co-ordinates that I need to find the pairs for and manually this would take forever. I was hoping some VBA guru out there would be able to find an automated process for finding the pairs.

I have posted an excel sample file below that you can work off if you find this easier.

Any suggestions would be greatly appreciated!

10357