|
Find the Closest Zip Code With Microsoft Excel Microsoft Excel "custom functions" can do many specialized tasks related to address and zip code information, such as checking the validity of mailing addresses, importing demographic information, even calculating driving time and driving distance. Custom functions, also referred to as UDFs (user-defined functions) perform complex calculations or tasks and are used in cell formulas just like the standard Excel functions SUM or AVERAGE. In this article we describe how to use custom functions to identify which zip code (within a list of zip codes) is closest to a target location. [VIEW ARTICLE]Comments RSS Feed For This Article: |








Subject: thanks very much for this article
I was looking for an application that would integrate with an excel spreadsheet to perform this and only this exact function. I didn't think I could just use Excel itself to handle it. Thanks so much for taking the time to write this up.