Zip Code Radius Search within Excel

[robinstine]

I need a zip code radius search that can be done within Excel and that can either select or sort my addresses to show which of them would fall within a particular radius search (for example 5, 10 or 20 miles). This is for targeted marketing purposes. Any thoughts on how this can be done?
Robin

 

[Oaktree]

Welcome to the board.

I think you have two choices:

1) Buy (or download for free if you can find one) an add-in which will do the calculation for you (I know nothing about this company, but the first hit on Google was http://www.business-spreadsheets.com/solutions.asp?prod=232 )

2) Download the latitude/longitudes of each zip code and do the calculation (or make the UDF) yourself. One hit returned by Google is http://databases.about.com/od/access/a/zipcodedatabase.htm