Does latitude and longitude fall within area?

WorldWideWalt

New Member
Joined
Jul 28, 2015
Messages
3
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
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,318
Office Version
  1. 365
Platform
  1. Windows
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
 
Last edited:

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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
 

Watch MrExcel Video

Forum statistics

Threads
1,119,063
Messages
5,575,907
Members
412,689
Latest member
nhsmedic
Top