# Distance Between (x,y) points Macro Help

1. ## Distance Between (x,y) points Macro Help

*user deleted post*

2. ## Re: Distance Between (x,y) points Macro Help

Can you attach a sample workbook with some dummy data showing your spreadsheet layout before a macro is and then a results sheet of what it would look like after? To attach a file, click Go Advanced at the bottom of the screen scroll down to the Manage Attachments button, browse to the required file, and then push the Upload button.

3. ## Re: Distance Between (x,y) points Macro Help

Hi,

I think a macro is not needed. Please check out the attached file. I hope I didn't make a mistake in the math formula
Book1.xlsx
Regards,
Alex

4. ## Re: Distance Between (x,y) points Macro Help

*user deleted post*

5. ## Re: Distance Between (x,y) points Macro Help

In Columns E and F how do you get those numbers (the math)?

6. ## Re: Distance Between (x,y) points Macro Help

First of all, I assume your "real" data doesn't have just "1" or "10" as point locations? Also, if you are calculating the distance between the two points, why are there 2 columns of results? X to Y is the same distance as Y to X as far as I know?

7. ## Re: Distance Between (x,y) points Macro Help

*user deleted post*

8. ## Re: Distance Between (x,y) points Macro Help

*user deleted post*

9. ## Re: Distance Between (x,y) points Macro Help

Ok, here is a starting point. Check this macro and see if it works for you?

``Please Login or Register  to view this content.``

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