Count number of names on a mailing list that are in each zip code

[mtf]

I have basic experience using excel and this is the first time to use a forum.

Problem: I have a mailing list and I want to know how many names are in each of the zip codes.

Thank you.

Mike

[zbor]

Can you upload example workbook?

make sure to remove all private data as names, e-mail address etc.. But leave formatting important for your problem.

[jeffreybrown]

Hello Mike & Welcome to the Forum,

A pivot table would work well in this situation.

[mtf]

Attached is a small sample, with the names and addresses deleted. Note some of the zip codes are 5 digit and some are 9 digit. Thanks.

[Fotis1991]

Hi

In fact you want to know, how many times a zip code, appears. Or this is not correct? If so, in F2 and copy down.

=COUNTIF($B$2:$B$21,B2)

[mtf]

You are correct. I want to know how many times each zip code appears. The countif you sent seems to tell me how many different zip codes there are.

[Fotis1991]

No. I do't think so.

See the example.

[mtf]

Thank you for the quick answer and solution.

[Fotis1991]

You are welcome.

Thanks for the feedback and for reb*