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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems created by Recent updates to Outlook 365 0
Mailing address block: sorting 1 row to columns 1
Cannot sort a table containing text 5
Filter ZIP codes into ranges 6
Is this possible? 0
Insert name and adress from a list in a word document 1
filtering a mailing list 4
how to sort the rows based on data in one column 3

Top