Assuming you have only the names column (Col A) then enter this in B1 and
copy down
=COUNTIF(A:A,A1)

Altenatively
enter 1 against each name in Col B.
Then create PIVOTTABLE using A:B as range
It will give you the count

Let me know how it goes....

"da" wrote:

How can I calculate the number of times same name appears in list of 400 names?
Thank you