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

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