Originally our sales territories were set up with zip code ranges. Our new requirements are to have each zip code listed, based on a limitation on the new version of the territory tool we use.
So I need to take our existing range lists and convert them, without duplicates, to list each zip code. Each zip code must be a valid zip as well. So far I haven't found a non manual way to do this and I am hoping for your help.
Here is a very small sample of my current data. In the first row below, I need it to spit out 90803 as the missing value. I would also need to know if there are any zip codes between 90804 and 90806.
<tbody>
</tbody>
So I need to take our existing range lists and convert them, without duplicates, to list each zip code. Each zip code must be a valid zip as well. So far I haven't found a non manual way to do this and I am hoping for your help.
Here is a very small sample of my current data. In the first row below, I need it to spit out 90803 as the missing value. I would also need to know if there are any zip codes between 90804 and 90806.
90802 | 90804 |
90806 | 90808 |
90813 | 90815 |
91708 | 91711 |
91723 | 91724 |
91739 | 91741 |
91761 | 91768 |
91791 | 91792 |
91901 | 91903 |
91905 | 91906 |
91908 | 91917 |
91931 | 91935 |
91941 | 91948 |
91950 | 91951 |
91962 | 91963 |
91976 | 91980 |
92003 | 92004 |
92007 | 92011 |
92013 | 92014 |
92018 | 92030 |
92036 | 92040 |
92051 | 92052 |
92054 | 92061 |
92064 | 92072 |
92074 | 92075 |
92078 | 92079 |
92081 | 92086 |
92090 | 92093 |
92101 | 92124 |
92126 | 92140 |
92142 | 92143 |
<tbody>
</tbody>