Hi

I have an Excel workbook with 2 columns (Zip Code and Rep). I want to show the data so that for each rep I can see the range of zip codes. For example.

This is a sample of data;

Zip Rep
1001 4108
1002 4108
1003 4108
1004 4108
1005 4108
1007 4108
1008 4108
1009 4108
1010 4108
1011 4108
1012 4108
1013 4111
1014 4111
1020 4111
1021 4111
1022 4108
1026 4108
1027 4108
1028 4111

And what I want to get is the following;

ZipFrom ZipTo Rep
1001 1012 4108
1013 1021 43111
1022 1027 4108
1028 1028 4111

So I can easily see that rep 4108 is covering all zip codes from 1001 to 1012, and that 43111 is covering from 1013 to 1021, etc.

Is it possible?

I tried pivot table using max and min on the zip code but that didn't give me the ranges I needed. Can a formula solve this or does it need VBA.

Any help is greatly appreciated.

Thanks