That Pivot Table is the ticket
Once I messed around with it it was great
Thanks


"SteveG" wrote:


If your addresses are broken out into separate cells (Street in A, City
in B and zip in C) you could use a simple Pivot Table. Assuming your
header is in
C1 and your range is C1:C100. Select the range, click on the Pivot
table wizard. When step one appears, click next. Step two should have
your range in it if you selected it before opening the wizard so click
next. Click on Layout. Your header should appear on the right. Drag
that to the Row section and then again to the data section. The item
in the data section should say "count of zip" if your header in C1 is
zip. Select where you want the Pivot Table to be and click on finish.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=554694