sorting mailing lists

S

Steph

I need to sort a mailing list by zip code and then find out how many entries
there are for each zip code. Can Excel do this for me?
 
J

JE McGimpsey

Steph said:
I need to sort a mailing list by zip code and then find out how many entries
there are for each zip code. Can Excel do this for me?
Click to expand...

Yes. The easiest way is if your mailing list is in records with zip
codes in a separate column. Then use Data/Sort to sort the list.

You can easily get a count using a Pivot Table - that doesn't require
that the data be sorted. See

http://peltiertech.com/Excel/Pivots/pivotstart.htm
 
Top