Counting text occurrences in a column

[KaiserD2]

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

[mehmetcik]

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.

[mehmetcik]

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.

I didn't create it. But found it on this site listed under sheet based unique list.

Column B is a list of entries

The length of that list is stored in the named range "List"
The start row of the output is stored in the named range "List_Start"

an array formula entered using ctrl & shift & enter is used to enter the formula in column B.

Please Login or Register  to view this content.

[Tony Valko]

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

[KaiserD2]

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

[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.

[KaiserD2]

that worked!!! Many thanks.

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.

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.