Need some work done? Post a Project Today
Attention Scriptlance users, Scriptlance has been acquired by Freelancer.com! Find out more
I have an excel list of about 780 cities in the US (includes this information ie: Riverside, Anaheim CA US)(Attached File Charter Internet). I also have another excel list with 3300 cities including state, county, city(attached file time warner residential). Lastly, I have a list of 42,000 zip codes from the US (with city, county and state information included as well) (Unfortunately this file is too large to be uploaded so please message me on freelancer to obtain). I need all the zip codes on the third list that correspond to the cities on each of the first two lists to be matched up and compiled in to two new separate excel worksheets. Please keep the the lists of cities completely separate (Do not mix Charter with time warner) and add all the corresponding zip codes, some cities will have multiple zip codes applicable. If it makes sense, it is possible to add a zip code column to the existing city lists as long as all zip codes for each city are matched correctly.
Additional Project Description:
02/05/2013 at 20:44 GMT
To clarify I would like cities and zip codes only for both lists, still keeping them independent of one another and I have attached a sample of the zip code file I have available. As seen in the file, there are multiple zip codes for the city of Birmingham so I would need each of those listed out individually for that city, not in any type of grouping (ie. 20000-20009)
Freelancer.com (formerly GetAFreelancer, Scriptlance and vWorker/Rentacoder) is the world's largest freelancing, outsourcing and crowdsourcing marketplace for small business. Hire freelancers to work in software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services.
Find freelance jobs and make money online! We have freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, custom programming, professional writing or affordable marketing has never been easier!
© Copyright 2013 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)