EzineArticles - Expert Authors Sharing Their Best Original Articles



  Submit Articles
  Members Login
  Benefits
  Expert Authors
  Read Endorsements
  Editorial Guidelines
  Author TOS

  Terms of Service
  Ezines / Email Alerts
  Manage Subscriptions
  EzineArticles RSS

  Blog
  Forums
  About Us
  Contact Us
  Article Writing Shop
  Advertising
  Affiliates
  Privacy Policy
  Site Map


Advanced Search


Find the Closest Zip Code With Microsoft Excel
By Betty Hughes


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:    RSS

1
frank cougar writes:

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.

Comment provided October 21, 2009 at 8:55 pm

Post a comment

Name:   (required)
Email:   (will not be published) (required)
Web URL:  
Subject:   (required)
Comment:
Notify me of followup comments via e-mail
Read Captcha PhraseRefresh Captcha
Please enter the captcha phrase you see here
 


ARTICLE COMMENT GUIDELINES
Important Disclaimer: Article Comments provided on any EzineArticles.com article are for general information purposes only and are not intended to substitute for informed professional medical, psychological, tax, accounting, legal, investment, or any other professional advice. EzineArticles.com expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in these comments or anywhere else within the site. Lastly, EzineArticles.com does not endorse any article comment. Use at your own risk.

© EzineArticles.com - All Rights Reserved Worldwide.