I have an Excel file composed of all our franchise locations and also a list of all locations for a large client. I need to figure out how to find out, for each of the client's locations, (A) what the closest franchise location is; and (B) how far away that location is from the client location. Is this possible?
Our application doesn’t provide this unless you were to measure one at a time. We calculate straight-line distance from your first location to all other locations in your data, but that is it. You can double click the marker and it will open a google map for you.
Yes, that is a solution. I was thinking you needed all this data output. Hope it works for you.