+ Reply to Thread
Results 1 to 2 of 2

Sort by location distance

  1. #1
    Registered User
    Join Date
    02-14-2011
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    20

    Sort by location distance

    I'm a little stumped on this one...

    To keep it simple, I have city, state, and zip code. Some zip codes are missing entirely, which is making this difficult.

    I need to sort the cities in relation to how close they are to each other. For example, any cities that surround Los Angeles, and any cities that surround San Francisco. I have cities all over the US, though. I'm not sure how to do this without going through one by one. In addition, I don't know all these cities. I barely know all the cities around where I live . It seems as though this could take a very long time.

    Here's what I was thinking I could do. Regardless of the appropriate zip code, as long as I can get a zip code associated with that city, then I could assign it to the cities that have no zip codes. Then, sort by zip. It wouldn't be perfect, but I would think it save a lot of time.

    What do you think?

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Sort by location distance

    Can you upload example?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1