Does latitude and longitude fall within area?

[WorldWideWalt]

Hello, first time poster. I have a list of zip codes and their corresponding latitude and longitude points from the US census bureau. I was hoping this data could be used to determine if a given zip code fell within a certain radius of another zip code.

In other words, if I could take the coordinates of an NYC zip code, create a 10 mile radius around that zip code, and determine if another zip code fell within that circle.

Is this beyond the ability of Excel 2010?

Thank you in advance,
WWW

 

[DRSteele]

This is certainly not beyond the capabilities of Excel nor of the abilities of some people on this forum. I don't know the entire solution, but this thread from earlier this year can get you started. See if any of it is relevant to your issue, especially the parts about calculating distances between LatLong coordinates. It should then be simple enough to calculate whether or not two circles overlap.

Read: http://www.mrexcel.com/forum/excel-...ongitude-coordinates-find-closest-office.html
and http://www.mrexcel.com/forum/excel-...etween-1000-latitude-longitude-addresses.html

 

[hiker95]

WorldWideWalt,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?


Here are some links in reference to latitude and longitude, that may help you:

convert some latitude and longitude coordinates from "Degrees, Decimal Minutes" format to "Decimal Degrees" format
How to convert degrees/minutes/seconds angles to or from decimal angles in Excel 2000
http://support.microsoft.com/kb/213449

How to get lat/long coordintates with VBA Excel

Resources for determining your latitude and longitude
How to find your latitude and longitude

Finding the location of a non-US city
Here are some sites that have the locations of major cities in the world.
http://www.realestate3d.com/gps/world-latlong.htm
Latitude and Longitude of World Cities (London, L.A., Paris, Singapore)

Try this udf it will help you in finding the time and distance between two cities using Google Map
Ashish Koul
http://www.excelvbamacros.com/
http://www.accessvbamacros.com/


Getting LAT and LONG from address - Page 2
Quick and easy geocoding for Tableau | Tableau Love

A Free Zip Code Database + Latitude and Longitude
Free Zipcode Database | Free Zip Code Database

Latitude, Longitude, And Great Circles
Latitude And Longitude