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.

"DTTODGG" wrote:

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

"will A" wrote:

=countif(a1:a2000,"sally")

"DTTODGG" wrote:

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!