Each row in my table represents a separate grouping of cards, the numbers indicate which card is present in the grouping (e.g. 1= Card 1). I need to figure out how to check if two cards are present in the same group, and then repeat that formula across each row, to check how many rows/groups contain the same two cards. For example, in the screenshot I am checking if row/group 2 contains both 8 and 15. I can’t figure out how to repeat this formula across each row in the data table to give me the total count of card pairings, in this case the total number of rows/groups where both 8 and 15 are present in the same row/group. Can anyone help me figure this out? 

​Each row in my table represents a separate grouping of cards, the numbers indicate which card is present in the grouping (e.g. 1= Card 1). I need to figure out how to check if two cards are present in the same group, and then repeat that formula across each row, to check how many rows/groups contain the same two cards. For example, in the screenshot I am checking if row/group 2 contains both 8 and 15. I can’t figure out how to repeat this formula across each row in the data table to give me the total count of card pairings, in this case the total number of rows/groups where both 8 and 15 are present in the same row/group. Can anyone help me figure this out?    Read More

​