Does anyone know if there is a function or formula avaialble that can be used
to compare 2 Addresses in a worksheet providing a distance in miles value
between them in the cell, probably linked to Map Point, geo points or lat/lon
coordinates. This would be used with one address as an absolute or constant
and the other would vary as the formula was applied adjacent to numerous
addresses listed in columns. I have Map Point 2004 and 2006. Obviously I am
trying to determine mileage from prospective customer addresses to a possible
store locaion.
Your help is appreciated!
Thanks,
--
Jerry Sharpee
CARQUEST Corporation
Professional Markets
Business Development Manager
Raleigh, NC