Hello, Thank you in advance for your help.

Data:
I have a list of names entered in a worksheet as follows: In Column A is the first group. For rows 1-7 I have a name. Each column after that contains 7 more names. They correspond to players on a team that were on the field for each point in the game. I want to be able to count the number of times the same players were on the field.

For example ( groups of 3 vertically)

Amy Brad Devin
Brad Amy Mike
Devin Devin Brad

I need excel to give me results that the combination of Amy, Brad, and Devin - in any order - occurred twice and that the combination of Devin, Mike, and Brad occurred once.

I am familiar with the IF & COUNTIF functions.

Thank you.
.