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!
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!
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
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?
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: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.Formula:Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks