To Identify Repeated Values

Closed
DP - Mar 10, 2015 at 10:19 AM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Mar 11, 2015 at 04:53 PM
Hello,
Please help with this issue.
I have a list of players in column 1 and column 2. I would like to know, for instance how many times "Allan"(player 1) comes face-to-face with "mike"(Player 2).
Like wise, I would like to match each member in player 1 to a specific player in player 2.
Date Player 1 Player 2
16-Feb Allan Mike
17-Feb john Sam
18-Feb victor Sam
19-Feb Allan Mike
20-Feb Ron Sam
21-Feb Allan jo

Hope, I explained my concern. Looking forward for a solution in Excel

1 response

cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 7
Mar 11, 2015 at 04:53 PM
Hello,

Might you not concatenate the entries in a blank column and do a count function on the range with the selection coming from the concatenated column to determine the number of times they've met?

Just a suggestion....
0