# Count number of times a specific word appears

1. ## Count number of times a specific word appears

I would like to count the number of times a name appears in c31:u31 and post the name only once in x16:x26 and the number of times the name appears next to it in z16:z26. Any help with this would be greatly appreciated!

2. ## Re: Count number of times a specific word appears

First unmerge cell X16
in Cell X16 use:
{=IFERROR(INDEX(\$C\$31:\$U\$31,MATCH(0,COUNTIF(\$X\$15:X15,\$C\$31:\$U\$31),0)),"")}
Remember CTRL+SHIFT+ENTER, then copy down to cell X26
in Cell Y16 use:
=IF(X16="","",COUNTIF(\$C\$31:\$U\$31,X16))
Then copy down

3. ## Re: Count number of times a specific word appears

Thank you! One last addition to this that I didn't think of: I would like the x16:x26 to exclude No Skin in the count. Is this possible?

4. ## Re: Count number of times a specific word appears

Originally Posted by csepesy
I would like the x16:x26 to exclude No Skin in the count.
This proposed solution builds on the one that we discussed in one of your previous threads and employs two helper columns.
Column AG is populated by the formula:
Formula:
`Please Login or Register  to view this content.`
Column AH, which breaks ties (test by changing Eric's score on the fifth hole from 2 to 3) is populated by the formula:
Formula:
`Please Login or Register  to view this content.`
X16 and down is populated by the formula:
Formula:
`Please Login or Register  to view this content.`
Y16 and down is populated by the formula:
Formula:
`Please Login or Register  to view this content.`
Let us know if you have any questions.

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