Similar data from groups

Closed
Report
-
Hello,

Looking to see what similar data are in groups of data... In the example below, Group 1 Participant 1 selected 65. I need to know from other groups that selected 65 if they also selected 54 and 35. So in Group 1 they selected 65, 54 & 35 but in Group 2 they only selected 65 & 54 but not 35. So in an Ideal world I'd like to select Group 1, Participant 1, 65 and run a script or formula that gives me the result of Group 2, Participant 2, 65 & Group 2, Participant 2, 54.. The only two similar ones in each group...

Group 1 65 Participant 1 Group 2 65 Participant 2
Group 1 54 Participant 1 Group 2 19 Participant 2
Group 1 35 Participant 1 Group 2 54 Participant 2
Group 2 72 Participant 2
Group 2 80 Participant 2
Group 2 7 Participant 2
Group 2 48 Participant 2
Group 2 11 Participant 2

Any ideas would be great.