Software·43,881 discussions

EXCEL

Locked

I need to calculate distances between two sets of northing/easting coordinates and display that distance in an adjacent cell. Any suggestions?

Topic

Clarifications

In reply to EXCEL

Clarifications

This might help you with your set points in Excell

In reply to EXCEL

http://www.movable-type.co.uk/scripts/latlong-vincenty.html

Please post back if you have any more problems or questions.
If this info is useful, please give a thumbs up. Thanks

THANK YOU

In reply to This might help you with your set points in Excell

Thank you for your time. I appreciate it. Although, I wasnt clear enough in my post. I am trying to do this formula in Microsoft Excel.

The equations are in that web page………..

In reply to THANK YOU

The equations needed for calculating that information are displayed on that web page. All you need to do is convert them to Excel formulas.

Oh! Wait! Were you asking for one of us to do it for you? How much $$$ do you have? Our time isn’t cheap. 😉

HINT: It’s going to take multiple cells to create all those formulas, eventually bringing your answer back to that “answer” cell.

Ok, read more here….

In reply to THANK YOU

http://bluemm.blogspot.com/2007/01/excel-formula-to-calculate-distance.html

Please post back if you have any more problems or questions.
If this info is useful, please mark it helpful. Thanks

PERFECT!

In reply to Ok, read more here….

Thank you! The second web page HELPED ALOT!
Although I wish I could have just paid you to do it! 🙂

[Author]

Replies