Hoping you have Excel 365 - otherwise, this has to be done differently and with helper cells. I will replace your unknown-to-me distance calculation with my oversimplified dummy formula based on pythagoras distance that looks at each Point's distance to Path Start and Path End and adds them. So, in my metaphorical formulation, I am going to find the nearest vs based on versus and in a reformulated version of your table, but put into an Excel Table to make it more readable and easier to understand. I will replace the Distance from a point to a line or geodetic line with a simpler to understand Cartesian distance between two points. Modifying the Problem to Focus on the Question As your question is really about how to "find the exact or nearest path", I will focus on that and ignore the mechanics of calculating that distance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |