Get the nearest address according to zipcode
Hello All,
Please help me with this case ,I need a formula or macro to find the nearest & 2nd_nearest (SITE_id ) according to the entered zipcode in Column (J). as expailned in the attached example.
For further info please let me know .
thanks a lot, Wellous
Last edited by wellous; 11-24-2011 at 09:11 AM.
Your spreadsheet doesn't seem to have enough information. How are we to determine which areas are closest without knowing all mileages? Is it based on lowest numerical difference between zip codes (which doesn't seem foolproof to me)?
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
Re: Get the nearest address according to zipcode
Yes, it's based on difference bewteen zipcodes ..
i found a solution but still not very accurate... due to zipcode format.
Pls check the new example , range J6 & J7
Can you correct my formula to reflect the nearest site correclty?
Many thanks in advance
I had to create a helper column in A. You can hide it if you see fit, but it will have to be expanded if you add more to column B. I named this new range Zip2. I also fixed the problem of finding the true closest zip code, since before it thought that the closest zip to 74135 was 75201, rather than 74134.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
This is perfect, thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks