Count multiple occurances in a column

[Guest]

Hello-
I read thru many posts, but none have the same question - I don't think.

I have a column with names in it, maybe 50 unique names, but the column is
2000 cells long. I would like to know how many times each of the names is in
the column.

Sally = 25
Tom = 333
Bob = 2
etc.

Thank you so much!

 

[Guest]

=countif(a1:a2000,"sally")

 

[Guest]

Thank-you will, but, this would take 50+ IFs?
Is there a way to look for all the names and then count them?
Thanks

 

[Guest]

Use a pivot table. Then it won't matter how many different names there all.
It will count them all.

Make the name field both a row field and a data field. Ensure that the data
field(s) setting is set to count.

Excels help is pretty good on pivot tables as well.

Hope this is a start.

Bill Horton

 

[Peo Sjoblom]

Use a pivot table, add a header. select the range header and all and do
data>pivottable and pivotchart report, click next twice, click layout,
drag the header into the row and the data areas, click OK, click finish

done

 

[Guest]

If you are not familiar with pivot table (which is also a solution)
Put all your 50 names in B1:b50, in C1 type =countif(A1:a2000,B1:B50) and
copy up to C50.

 

[Guest]

Much happiness in Muddville!
Thank-you for your 3 solutions! I'm learning a lot with all of your help.
This is a great resource. Someday I hope to be answering questions, but for
now...
Again, thank-you!

 

[Guest]

Sorry should be =countif($a$1:$a$2000,b1:b50) with the dollar sign.