Find Zip Codes in a Radius using Excel
Loading...
Loading...
6,065
Loading...
Uploader Comments (bjhughesfs)
see all
All Comments (4)
-
thanks but next could you show Wilson's addresses
-
Thanks, it works now. Adding the Left function fixed it.
-
I tried this in Excel 2007 and all I get is #NA's for distance in the address list. Any ideas?
Loading...
3:24
Geocoder in Excelby bjhughesfs4,628 views- 1:56
Get City, County, and State from Zip Codesby bjhughesfs1,921 views
- 3:38
Free Zip Code Database Tourby zipcodeguy17,008 views
- 6:19
Autofilterby AuditExcel3,818 views
- 4:32
Route Optimization in Excelby bjhughesfs4,097 views
- 2:57
Zip Code List in Microsoft Excelby bjhughesfs14,071 views
- 2:08
Demographic Data in Excelby bjhughesfs1,254 views
- 1:55
United States Cities, States, Zip Codes, Area Codes, Longitude & Latitude Database for Downloadby eCommerceSiteOwners6,790 views
- 1:22
Get Latitude and Longitude for Addresses in Excelby bjhughesfs1,258 views
- 3:27
Grouping One Pivot Table Changes Anotherby contextures3,178 views
- 7:16
Excel VBA Pull Data From A Websiteby DontFretBrett5,959 views
- 1:55
Postal Zip Code Databaseby yrichard4563,897 views
- 4:55
Solve Your Zip Code Problems in Excelby DannyRocksExcels11,545 views
- 2:02
how to calculate radius of a circle given circumferenceby teachertubemath9,311 views
- 4:47
ZipFinderby baddogapps1,591 views
- 0:48
Super-Fast Search for Microsoft Excel 2007by alex940402,492 views
- 6:18
Find Targeted Keywords Using Excelby iantrepreneur3,290 views
- 5:14
RecordRadar™ - Zip Code & Constituent Locator for the Raiser's Edgeby OmaticSoftware547 views
- 1:46
Zip Code Radius Analysis in an Excel Templateby bjhughesfs173 views
- 2:10
ZIP Code Tools for Palm's webOSby spdsjtr8,898 views
jimsim31 - This does work fine in Excel 2007. A few tips: Make sure that the zip codes in your address list are formatted as 'text', as shown in the video. Also, if the zip codes in your list are in Zip + 4 format, use the formula =VLOOKUP(LEFT(D2,5),ZipList,2,False) so only the first 5 digits are used in the lookup function. And finally, check that there are no non-printing characters in the zip codes, which occurs sometimes when importing from another application. Hope this helps ...
bjhughesfs 2 years ago