Separate Unique Totals

[Michael]

Excel 2000
----------

I have seen this question asked before but am unable to
search for it as I am not sure how it is worded.

I have a list (spreadsheet of course) of addresses. I
would like to be able to know totals of how many address
are in each zip code. Does Excel have this function
included or is there a macro available to do this?

Thanks for any assistance anyone can provide.

Michael

 

[Dave Peterson]

You can sort your data and then do Data|subtotals
Or you could use data|pivottable to create a nice summary.

 

[Selvarathinam]

Put the following syntax in the cell if the zip code in column D and
copy the same till you want. this will show u each zip code with the
totals.

=IF(COUNTIF(D,D2)>1,COUNTIF(D,D2)&"("&D2&")"," ")

Regards,
Selvarathinam.

 

[Ken Wright]

Use a Pivot table and you won't have to create a single formula. Assuming
your data is in database format, and it sounds like it is, then select all
your data and do Data / Pivot table and chart report, then hit Next / Next /
Finish

Now drag the Zip code field into the space marked ROW fields, and then drag
it again into the area marked DATA

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------