My source table looks like this:

 Court 1Court 1Court 1Court 1WEEK 11627WEEK 25917WEEK 331015WEEK 461045WEEK 581073WEEK 61495WEEK 76215WEEK 88173WEEK 910296WEEK 104257WEEK 111236

I want to use that data to populate the table below with the total number of times in the entire table any 2 numbers occur in a single row.  So, for example, the number 3 would go in the circled cell because the combination 1 and 2 occurs in three of the rows in the source table (Weeks 1, 7 and 11).  Any help is appreciated.

​My source table looks like this: Court 1Court 1Court 1Court 1WEEK 11627WEEK 25917WEEK 331015WEEK 461045WEEK 581073WEEK 61495WEEK 76215WEEK 88173WEEK 910296WEEK 104257WEEK 111236 I want to use that data to populate the table below with the total number of times in the entire table any 2 numbers occur in a single row.  So, for example, the number 3 would go in the circled cell because the combination 1 and 2 occurs in three of the rows in the source table (Weeks 1, 7 and 11).  Any help is appreciated.   Read More

​