Hi, I'm not sure if this is possible but I am trying to count a combination of two cell values (Concatenate function) and if there are any reciprocals as one. Example:
<tbody>
</tbody>
I'd like to count Joe&Bob and Bob&Joe as 1 unique value because it is the same two person. Any thoughts on how to do this? Thanks!
A | B | C | D | ||
1 | Player 1 | Player 2 | Combined Player | Count | |
2 | |||||
3 | Bob | Joe | Bob&Joe | {=IFERROR(INDEX($C$2:$C$5,MATCH(0,COUNTIF($D$1:D2,$C$2:$C$5&"")+ IF($C$2:$C$5="",1,0), 0)), "---")} | Results = Bob&Joe |
4 | Joe | Bob | Joe&Bob | {=IFERROR(INDEX($C$2:$C$5,MATCH(0,COUNTIF($D$1:D3,$C$2:$C$5&"")+ IF($C$2:$C$5="",1,0), 0)), "---")} | Results = Joe&Bob |
5 | Bob | Joe | Bob&Joe | {=IFERROR(INDEX($C$2:$C$5,MATCH(0,COUNTIF($D$1:D4,$C$2:$C$5&"")+ IF($C$2:$C$5="",1,0), 0)), "---")} | |
6 | Joe | Bob | Joe&Bob | {=IFERROR(INDEX($C$2:$C$5,MATCH(0,COUNTIF($D$1:D5,$C$2:$C$5&"")+ IF($C$2:$C$5="",1,0), 0)), "---")} |
<tbody>
</tbody>
I'd like to count Joe&Bob and Bob&Joe as 1 unique value because it is the same two person. Any thoughts on how to do this? Thanks!