How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 1964
Experience:  Extensive Knowledge in PHP, MYSQL, CSS & Javascript
62934938
Type Your Programming Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

Lifesaver: am not a programmer but my research has given me

Customer Question

Lifesaver: am not a programmer but my research has given me VBA scripts. I need an Excel formula to calculate distance between to sets of lat/long
Submitted: 2 years ago.
Category: Programming
Customer: replied 2 years ago.
I can use several websites to do this but I have already geocoded the addresses. I want the distance, in miles, from Address A to Addresses B-whatever. If there was a way to simply limit the response to a 1 mile radius it would be a bonus.
Expert:  The-PC-Guy replied 2 years ago.
Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question
This sheet will provide the appropriate formulas, and give you the dist between lat1/lon1 and lat2/lon2. In both Mi and Km
http://ge.tt/2dp1obH2/v/0?c
---------------------------------------------------------------------------------------------------------------
let me know if you have any questions, problems, or concerns
PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME
IT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTION
TO RATE, CLICK THE SMILEY FACES BENEATH THIS ANSWER
Do not rate negatively, instead continue the conversation with me so I can address any of your concerns
---------------------------------------------------------------------------------------------------------------
if you have any questions in the future you can visit my profile
http://www.justanswer.com/computer/expert-1expert-2rulethemall/
and ask a question right in my box,
also you can put "PC Guy only" in your question title if you want to get to me.
Expert:  The-PC-Guy replied 2 years ago.
hi I provided you with a solution several days ago and have not received a response. I strive to provide the highest quality work.
I am following up to see if you needed anything further from me or if you are ready to complete this transaction