Convert list of zip codes into ranges

I have a list of zip codes that I need to convert into ranges. Column 1 - Zip Low, Colum 2 - Zip High.

This is a sample of my data:
Zip Code
19012
19013
19014
19015
19018
19020

This is my desired outcome:
Zip Low Zip High
19012 19015
19018 19018
19020 19020

HELP!

I am setting up territory data and our system requires the data to be loaded in that format.

Hi tregan,

You must have another column that 19012-19015 groups together and different from 19018 and 19020... city name, I assume...

Please attach a sample workbook for us to work with and several results that you want to see...

To attach a workbook, click on Go Advanced and look for a paperclip...

Thanks,
Dennis

zip ranges.xlsx

Here is the file with a sample of my data. I left in the columns where I was trying to generate a range xxxxx-xxxxx then I figured I would just do text to columns to get it into the desired zip low/zip high format, but I have not been able to figure out a way to generate the range formula.

Hopefully there is an easier way to achieve this. Thanks for your help!

Hi tregan,

You are so close...

In D2, keep 1

In D3 and the rest, use this formula instead... =IF(C3=C2+1,D2,D2+1)

What do you think?

THANK YOU!!! That worked!

I tried using the process described in the earlier threads, but I am getting repeated zip codes out of range (highlighted in yellow in the attached). Is can you suggest anything else? Thank you ! R