# Count number of times of name appears in a column

1. ## Count number of times of name appears in a column

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

2. ## Re: Count number of times of name appears in a column

Ness78,

Just put your formula in column b but replace "gia" with A2 like this =COUNTIF(\$A\$2:\$A\$442,A2) and drag down

3. ## Re: Count number of times of name appears in a column

Hi Ness and welcome to the forum.

See the attached with the answer.

4. ## Re: Count number of times of name appears in a column

Thanks for the welcome and for getting back to me so quickly!!

Works a treat!! I've been trying to figure this one out for ages! Should have joined this forum months ago.

Thanks again

5. ## Re: Count number of times of name appears in a column

Alternatively, use pivot tables..

6. ## Re: Count number of times of name appears in a column

@ Ness78

Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1