I've got a spreadsheet of addresses with the following columns: First Name, Last Name, Street Address, City, State, and zip code. I'd like to be able to filter or otherwise extract a subset of these address records based on a set of geographically close postal codes. We've been using http://www.freemaptools.com/find-zip-codes-inside-radius.htm to get a list of codes that are within a certain radius of the targe area. W
What's the easiest way to take the comma separated list of zipcodes from freemapstools.com to get a subset of addresses from the full mailing list spreadsheet?
For example: from our complete list of addresses, I want to see all addresses that have a zipcode in the set of: "55055,55119,55125,55129"
For what it's worth, we're using Google Docs, but if this would be easier in Excel that would be fine too.