Creating zip code ranges from one list - help

[gdl614]

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]

try this,

Excel Workbook
	A
1
2	90080
3	90081
4	90082
5	90083
6	90084
7	90086
8	90087
9	90088
10	90089
11	90091
12	90093
13	90094
14	90095
15	90096
16	90097
17	90099
18	90101
19	90102
20	90103
21	90174
22	90185
23	90189
24	90201
25	90202
26	90209
27	90210
28	90211
29	90212
30	90213
31	90220
32	90221
33	90222
Sheet1

Excel 2003

Excel Workbook
	C	D
1	From	To
2	90080	90084
3	90086	90089
4	90091	90091
5	90093	90097
6	90099	90099
7	90101	90103
8	90174	90174
9	90185	90185
10	90189	90189
11	90201	90202
12	90209	90213
13	90220	90222
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

 

[gdl614]

It works!! Thank you!

 

[mbrault2012]

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?