I am not sure if this is the most appropriate place to post this but here is the issue and feel free to tell me and easier way to do it if there is one.
I am trying to use API to mate parts according to hole location. I have made a macro that identifies hole locations and know i am trying to figure out how to match them up. down below I show two sets of data from different parts that go together.(I am only using excel to visually see the data the finished macro will only run in solidworks) I am stumped on how to go about further organizing the data to show that which holes mate together.