Calculating Distance In Excel

Stuck on a problem? Schedule a 1-Hour Consulting session with me.
www.bowerylabs...
In this video, I will show you how to calculate distances between zip codes in terms of miles and kilometers in Excel
DOWNLOAD LINK
www.bowerylabs...

[@ShinyEevee27]

Thank you, thank you, thank you SO MUCH!!! You have saved me so many hours of pouring over data and repeatedly going back to a map database I've been having to use for YEARS. This is a game changer for me!

[@Dijana.S]

God bless you for your selflessness and for sharing this knowledge with all of us. Saved me so much time, I cannot thank you enough!

[@doughughes257]

Thanks. This is exactly what I need for my church's outreach program to seniors living alone. It will allow us to pair seniors with someone who can check on them regularly in person post-pandemic. Many shut-ins suffered greatly during the last 15 months.

[@KaptainTech]

This is incredible, thanks for sharing!!

[@mbuenon]

The internet is God and it speaks to us through angels, and today, you are an angel. thank you!

[@jasmineechang]

Thank you so much for creating this! I was able to create a sensitive report for corporate leadership through your formulas.

[@rita4349]

This was SOOOO helpful, and you just saved me a TON of time. Thank you!!!!!

[@mikedavidson3145]

Not all hero's wear capes! Thank you so much!!!

[@agirl.and.hergolden]

This was incredibly helpful and saved me SO much time. Thank you for linking the document!!

[@junyosh4]

Wow. This is exactly what I was looking for. Super helpful, thank you!!!

[@EvenBetterCool]

This is absolutely brilliant. I didn't even think that someone would do it via Lat/Long and Trig..... You are a hero.

[@virginiam.kaplan6015]

This is amazing. Thank you so much for sharing!! Saved tons of time.

[@spreadsheetsExcel]

THANK YOU for your great insight of this and sharing it with everybody.

[@petergressick586]

Flipping amazing!! Exactly what I need!! THANK YOU!!

[@anjibabukuna336]

Thank you soo much, you have saved a lots of time for me.

[@marcelavillarroel3627]

This is just wonderful!! Thank you so much for sharing this, you've made my life easier. You are a star, Kaptain Tech!!

[@abdulrehmanbaloch2295]

weldon dear, from few day i was searching but your vedio help me alot. thanks

[@Nicephore]

Dude, you're the man. Thanks!

[@magdalenamcdowell1344]

True scholar and gentleman

[@martyryan4883]

Extremely helpful - thank you for sharing this!

[@vishnukk7645]

Thank you for this simple tutorial and the excel file..

[@carolwhaleyaddassi6167]

Excellent!!! Super-helpful and clear!!! Thank you so much!!!!!!

[@nepanjid833]

This was nicely taught! Extremely helpful and to the point. Thank you.

[@Porter_John]

Thank you for this!!

[@gordonpeckhamiii9542]

This was very helpful. Thank you very much

[@Supercoconus18]

Thank you so much for this!

[@ADTRscape]

Yeah this is awesome. Great work here.

[@magentaken8861]

Big help, thank you!

[@emersonlazellari3867]

Amazing and to the point!

[@christianm4994]

what is the unit of distance measured when we multiply by 3958.8? is it nautical miles or just regular miles

[@cupidcup2007]

Appreciate your video. Really helpful!

[@CB-ht6ln]

THANK YOU! So helpful!

[@AndersonsPlumbingIncInsp-ll3si]

Hello, I would love the template but the link says the website is expired. Can you assist?

[@beejdeej]

Really cool!!

[@morennamarina]

How did u get the latitude and longitude?

[@andreilaza9153]

=ACOS(COS(RADIANS(90-B2))*COS(RADIANS(90-E2))+SIN(RADIANS(90-B2))*SIN(RADIANS(90-E2))*COS(RADIANS(C2-F2)))*3958.8 you're welcome

[@AdityaTagat2014]

Thank you!

[@artiststevens]

Amazing! Thank you

[@chriscoleman7858]

How did you get the latitude and longitude for each zip code?

[@carolinaforcechlt]

This mileage is where the crow flies, correct? It isn't calculating driving distance like Google Maps, right?

[@patriciohuerta392]

How would you explain the secret sauce? I need to explain it on my report

[@ondrastiburek428]

it doesn´t work for Europe... is there any way to make it work? thanks

[@GurwellGlobal]

Is there a way to do this without the lat / longitudes? From zip to zip?

[@emjayleebradoo]

kzbin.info/www/bejne/i5etfKKrjdyVkNE

[@Jigneshmodi027]

This is for US only?

[@yellowheartz08]

Thank you so much!

[@porntipjunsang2521]

Thank you so mush. ^^

[@desireerivo]

Where can I find this worksheet?

[@maxmerzin7725]

How much variance do you think we have with actual roads and distance between two points?

[@mayanktripathi1310]

Hi Max, the distance is shown as the aerial distance between 2 points and not the actual road wise distance which google maps suggest.

[@mammiesanonymous]

This was great thanks! However, when I put the distance in using your spreadsheet and then use google maps, I'm getting a difference of 300 miles.... any idea why this could be happening? Thank you in advance.

[@Slayalldaygurl]

my issue too did you find a work around?

[@alisonj]

I think that this must calculate a straight line, not driving distance.

[@emjayleebradoo]

@@alisonj this one calculates driving distance kzbin.info/www/bejne/i5etfKKrjdyVkNE

[@curelessorc7044]

Brilliant.

[@mueez89]

Genius!

[@jahanarabiva6756]

Would you please describe me that why you multiply the formula by 3985.8 TIA

[@abdulrehmanbaloch2295]

this is redus or earth

[@adrienthevenot3875]

Would it be possible to get the same data but for Canadian Postal Codes?

[@youngwukim4753]

THANK YOU SO MUCH

[@MariaPonomarevaLeonid]

Merci!!

[@lengochai2807]

what is unit of distance? please

[@abdulrehmanbaloch2295]

it is mile , but i need kilo meter !

[@hanialnami7468]

Thank youuuuuuuuuuuuuuuuu