Count multiple occurances in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Thank-you will, but, this would take 50+ IFs?
Is there a way to look for all the names and then count them?
Thanks
 
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
 
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
 
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.
 
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!
 
Back
Top