| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Regrouping large lists into areas based on zip codes
I receive lists of about 200 addresses covering about 40 zip codes. I have
to separate and re-group this list into 7 areas based on zip codes (which aren't serial, of course). I've considered using IF.THEN..ELSE formulas, but fear that would be too complex. Does anybody have any simple, elegant solution? Thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have a cell return one of severl lists based on data from another | Excel Discussion (Misc queries) | |||
| How do I validate data using different lists based on the data in. | Excel Discussion (Misc queries) | |||
| Format text based on which of several unique lists the value belongs to? | Excel Worksheet Functions | |||
| finding common numbers in large lists | Excel Worksheet Functions | |||
Threaded Mode
