Excel provides a quick way to count items in a list using a PivotTable. Let’s see how:
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
Here is a list of contest winners by date. I want to know how many times each has won:
An easy way to do this is using a PivotTable. Just highlight the data, go to the Insert tab and insert a PivotTable:
Then just drag the Winner data into both the Rows and Values fields, and voila!, you have your count:
Easy as that!