There are probably several solutions, but I would opt for generating a Pivot Table from your dataset. If you are unfamiliar with PTs then I urge you to look at this web site and view the tutorials on Pivot Tables. You can set your sort by zip, by store, by customer.
http://www.datapigtechnologies.com/ExcelMain.htm
Alan
Bookmarks