Summing number of entries for many different entries

lackofzack

New Member
Joined
Dec 5, 2017
Messages
2
Hello,

I have a data set I am working with where I have a long list of zipcodes. I need to count for each individual zipcode, how many entries there are.

Here is a picture of my spreadsheet:

https://imgur.com/7mEewe5

I am having trouble attaching excel sheet to this post, so here is a dropbox download link: https://www.dropbox.com/s/cmgppdsmxa...zips.xlsx?dl=0

What I am looking for is a count for every individual zipcode of how many entries there are with that zipcode.

So it should looks something like:
For zipcode 90001: 251 entries
For zipcode 90002: 74
etc for all the zipcodes.


Thanks in advance!
Please let me know if you have any questions/need clarification

Zack
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,108,727
Messages
5,524,478
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top