Hi guys,
I'm hoping someone can help me. I need to count the number of times a name appears in a column. For example, Column A has the following names:

gia
gia
gia
gia
gia
gia
jon
jon
Roger
Roger
Roger
Roger

I would like a formula so that Column B tells me the number of times the name in that cell appears in the rest of the column. So for gia the answer should be 6, for jon the answer should be 2 and for Roger the answer should be 4. I have data set is quite large that I imagine I could not use this formula =COUNTIF($A$2:$A$442,"gia") because to do this I would need to manually insert the name each time.

Can anyone help me out?

Thanks