Counting text occurrences in a column

I am working on a big project involving baseball statistics, evaluating individual seasons. After a great deal of entertaining data gathering, I have a spreadsheet of 1896 seasons that meet certain criteria--that is, seasons belong to an individual player. The player's names are in column A of my spreadsheet.

Individual names appear between 1 and 15 times. I would very much like to generate a quick table (or just a couple of columns) that lists every name in column A, and how many times it appears. My understanding is that the histogram function won't work with text. Can some one tell me how I can do this? Thank you. I'm running Excel 2013 on windows.

KaiserD2

There are numerous ways this can be done.

But I am thinking you probably don't need to use Macros for this.
So I have a spreadsheet that might work for you.

Originally Posted by Tony Valko

Is this a one-time task or is it something that should be dynamic?

It does not have to be dynamic. My thanks to Mehmetcik but I would appreciate something simpler.

DK

that worked!!! Many thanks.

Originally Posted by Tony Valko

Try this...

Let's assume you want the list of unique names to be placed in column D starting at cell D1.

Select the range of names in column A including the column header.

Goto the menu Data>Filter>Advanced
Select: Copy to another location
List range should already be entered
Copy to: D1
Select: Unique records only
Click OK

Enter this header in E1: Totals

Enter this formula in E2:

=COUNTIF(A:A,D2)

Copy down as needed.