Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
    
Thanks for the quick answers. Both suggestions work great if we're only trying to filter by a few zipcodes at a time. However, it's not uncommon for us to have a subset of 20 or 30 different zipcodes for an area. Manually checking or selecting those zipcodes one at a time is not very easy or fast. I'm hoping for a faster solution. –  DaveE Nov 10 '11 at 3:24
add comment

2 Answers

In your google doc spreadsheet, go to Data->Filter. Click on the boxed down arrow that appears in the header of the zip column. Click on "clear", then type in your desired zipcodes and click on them when they come up (they should be checked).

share|improve this answer
    
I'm hoping there's a faster method as we often have 20+ zipcodes we'd like to filter by. typing and checking them one-by-one is pretty tedious. –  DaveE Nov 10 '11 at 3:28
add comment

In Excel 2007 and 2010 the filter options use checkboxes on all applicable values to allow custom selection of any given combination for any given filtered column.

Instead of being presented with a list of the possible values and then whichever you select you get those filtered, such as in Office version 2003 and before, you get a series of checkboxes in 2007 and later. This is less efficient for those times that you only want one particular value, but it's much more powerful in the custom selection capability.

share|improve this answer
    
I'm hoping there's a faster method as we often have 20+ zipcodes we'd like to filter by. Checking them one-by-one is pretty tedious. –  DaveE Nov 10 '11 at 3:28
    
Yes it is. I assume it wouldn't be too difficult to write a macro that allows you to enter zip codes you wish to filter by. The current system is definitely an improvement from before, though it's more "average user"-friendly than it is "advanced user"-friendly. –  music2myear Nov 10 '11 at 15:03
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.