Creating zip code ranges from one list - help

gdl614

New Member
Joined
Oct 26, 2005
Messages
13
Hello,

I have a long list of zip codes (this is just a small portion of the list) that I need to make into ranges. Is there a formula I can use?

From this list:
90080
90081
90082
90083
90084
90086
90087
90088
90089
90091
90093
90094
90095
90096
90097
90099
90101
90102
90103
90174
90185
90189
90201
90202
90209
90210
90211
90212
90213
90220

To this:

To From
90080 90084
90086 90089
90091 90091
90093 90099
90101 90103
90174 90174
90185 90185
90189 90189
90201 90202
90209 90213
90220 90220
 

sanrv1f

MrExcel MVP
Joined
Jan 1, 2009
Messages
3,468
try this,
Excel Workbook
A
1
290080
390081
490082
590083
690084
790086
890087
990088
1090089
1190091
1290093
1390094
1490095
1590096
1690097
1790099
1890101
1990102
2090103
2190174
2290185
2390189
2490201
2590202
2690209
2790210
2890211
2990212
3090213
3190220
3290221
3390222
Sheet1
Excel 2003
Excel Workbook
CD
1FromTo
29008090084
39008690089
49009190091
59009390097
69009990099
79010190103
89017490174
99018590185
109018990189
119020190202
129020990213
139022090222
Sheet1
Excel 2003
#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Note: This requires a blank row above the data
 

mbrault2012

New Member
Joined
Jul 9, 2013
Messages
1
Got it working too. Would it be possible to add a 3 bit to the array to give ranges for each unique value in a 3 rd column when unique?
 

Forum statistics

Threads
1,082,438
Messages
5,365,531
Members
400,837
Latest member
ELMST616

Some videos you may like

This Week's Hot Topics

Top