| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter ZIP codes into ranges
On 28/01/2012 12:27 PM, mscir wrote:
On 1/27/2012 5:05 AM, Vacuum Sealed wrote: On 27/01/2012 4:53 AM, ronsmail wrote: I am working on a project to take a list of ZIP codes (29,133 rows) and sort it by territory, then find all ZIPs in that territory that are in sequential order and make a ZIP range from the 2 extremes in the sequential group. The logic behind what I want to do goes like this: Sort by Region code, then by Zone #, then by ZIP code. Find all groups of ZIP codes sequentially ordered and append the first ZIP in the group to column X and the last ZIP in the group to Column Y. Hi Ron Try this link for Debra Dalgliesh http://www.contextures.com/xlDataVal15.html It provides the steps for setting up a dependent data validation list which may help with what you are looking for. HTH Mick. That looks a lot more straight-forward, not to mention easier, than what I proposed. Mike --- Posted via news://freenews.netfront.net/ - Complaints to --- Happy to help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with zip codes and filter | Excel Discussion (Misc queries) | |||
| Need to convert list of 5 digit zip codes to ranges where possible | Excel Worksheet Functions | |||
| Date ranges and advanced filter | Excel Programming | |||
| How to create ranges with auto filter | Excel Programming | |||
| Multiple ranges to Auto Filter | Excel Programming | |||
Threaded Mode
