# Length and distance from the line coordinate and point coordinate

1. ## Length and distance from the line coordinate and point coordinate

Dear Experts,

I am trying to find out the distance and length of perpendicular points from line coordinates. I already have an excel file that detects the distance and length of the point but it is a difficult one. It can only know one line from coordinates. This is another way to find out from several coordinates of the line.

Thank you in advance

2. ## Re: Length and distance from the line

How does this differ from your post of yesterday, i.e.:

https://www.excelforum.com/excel-pro...ml#post5071793

which you had marked as Solved?

Is this a duplicate thread?

Pete

3. ## Re: Length and distance from the line

Hi pete _UK,
No, it's not a duplicate thread Both have different requirements You read carefully.

4. ## Re: Length and distance from the line coordinate and point coordinate

Is there no solution?

5. ## Re: Length and distance from the line coordinate and point coordinate

I'm sure there is a solution -- it is more about understanding your exact requirements and figuring out the desired algorithm.

Like Pete, I am not sure I understand what is different about this question and the previous one. Can you elaborate? Considering the success of karedog's solution in the other thread, it might be easier to start with his VBA code and adapt it to the new requirements for this question rather than start from scratch.

It also might be important to know if, like the other thread, you are trying to replicate an AutoCad calculation -- just in case there is something about the AutoCad method that needs to be taken into account.

If I were starting from scratch on this question, it looks like the question should reduce down to the "distance from a point to a line defined by by two points" formula given by Wikipedia: https://en.wikipedia.org/wiki/Distan..._by_two_points I expect that, if I were starting from scratch, I would start there. The main complication I see beyond the basic formula is that your problem needs to decide which line segment to use. I'm not sure, but I expect that I might use some kind of trial and error algorithm for that.

Before spending a lot of time exploring this, can you clarify your requirements? Do you understand karedog's solution in the other thread to suggest how it needs to be modified for these requirements? Are there specific parts of this you need help with, or, like with the other thread, do you need someone to develop the entire solution for you?

6. ## Re: Length and distance from the line coordinate and point coordinate

This thread has been duplicated. Because there are answers in both I am going to close this one. Continue in the newer one which has additional attachments. (I was unable to merge them.)

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1