Excel - Calculate the Distance Between Two Locations and Show on a Map

[@zibbity]

Thank you so much for not wasting time! We are looking for something that is Mac specific, and the fact that you shared that this was only possible in windows, was very helpful!

[@MikeThomas67]

You are so welcome!

[@halliecampos2271]

I did not find this helpful for my purposes, but THANK YOU for being so transparent with your not wasting time. This was BRILLIANT, and I appreciate you!!

[@MikeThomas67]

@halliecampos2271 Thank you for taking the time to comment ❤️

[@jacklaval]

That part ^^ Thank you kindly! I appreciate your transparency! And still super helpful information 🤜🤛

[@yellowdeucetennis]

This is awesome, thanks!

[@MikeThomas67]

Glad you like it!

[@excel_ladz]

This is excellent! Thanks so much lad 🔥

[@ViniciusDalviTrancoso]

It helped me so much, thank you, professor

[@dandan_noodles_]

Very helpful! Thanks!

[@MikeThomas67]

You're welcome!

[@idontknowexcel]

Just confirming, the map would be static. One could change the locations, but the map will always stay the same. Is that accurate?

[@MikeThomas67]

@idontknowexcel Using my solution yes the map is static. That's the one downside of the 3D Map tool

[@Awesome-Imalive]

Great video! I´m trying to figure out how to find the X,Y distance between 4 cities, using a city as reference (0,0). Do you know how can I do this?

[@mario17-t34]

Thanks so much, was so easy, can it work with real street addresses let say in the same city?

[@MikeThomas67]

@dai786 If you have the longitude and latitude of the address then yes. Google "longitude and latitude of specific address" for how to get that information

[@mario17-t34]

@@MikeThomas67 Thanks Mr.Thomas, alas not long/lat available, need to run it thru API

[@mario17-t34]

@@MikeThomas67 Thanks Mr.Thomas. Yea I need to learn Long/Lat first, my input only street address

[@arpitkumar7848]

Would it be possible to get the same done for list of countries, sites , address, Pin code and find which all are nearby each other and form a cluster

[@MikeThomas67]

@arpitkumar7848 As long as you have the longitude and latitude for the location you should be able to calculate the distances. Unfortunately Excel can't generate these for countries and addresses but there are plenty of resources online where you can get that information

[@emjayleebradoo]

kzbin.info/www/bejne/i5etfKKrjdyVkNE

[@unohoncho7727]

I like it but there seems to be a degree of inaccuracy if you compare to the AA distance calculator - That doesn't mean the AA calculator is right of course (I don't even know how they calculate their distances) but I have to change the * 3959 value in the formula to 4700 to get it to somewhat compare (even still with a degree of inaccuracy when I've checked differing distances) - What is the * 3959 representative of?

[@MikeThomas67]

@unohoncho7727 Not being a maths whizz, I took the information from here: stackoverflow.com/questions/11879053/driving-distance-between-two-coordinates. And I don't know how the AA works it out either. But the method I used uses longitude and latitude of the specified locations

[@il_han8867]

Very nice work, thank you. How is it calculated as driving between two distances?

[@abhim964]

Does it give the shortest distance between Manchestor and London or distance by road? if i need to calculate distance by road from Manchesor and London, what is the formula ?

[@robertreedholm3217]

My Excel does not have the geographic selection. how do I add that to excel?

[@MikeThomas67]

@robertreedholm3217 What version do you have? Use File > Account to check

[@oliviahamelius4353]

Why did you use a factor of 3959 in the formula?

[@MikeThomas67]

@oliviahamelius4353 I Googled and came across this website where someone had kindly created the formula I needed: stackoverflow.com/questions/11879053/driving-distance-between-two-coordinates

[@danielledavidson4455]

How do you change to KM instead of miles

[@MikeThomas67]

@danielledavidson4455. Edit the formula: =INT(ACOS(COS(RADIANS(90-B4)) * COS(RADIANS(90-B5)) + SIN(RADIANS(90-B4)) * SIN(RADIANS(90-B5)) * COS(RADIANS(C4-C5))) * 3959) Change the 3959 to 6371 Thanks to: stackoverflow.com/questions/11879053/driving-distance-between-two-coordinates

[@RichardBenjaminYrastorza]

I'm getting #num! error after I placed in the long and lat