Table:
1 2 3 5 6 8 9 11
2 3 6 7 9 10 11 12
1 2 4 5 6 9 11 14
Output:
1 2: 2
2 3: 2
3 4: 0
4 5: 1
5 6: 2
6 7: 1
7 8: 0
8 9: 1
9 10: 1
10 11: 1
11 11: 1
12 13: 0
I’ve tried countif w/ AND, countifs, vlookup, filter, as well as various methods of concat. I haven’t found any method that seems to get me in the ballpark. I don’t think Sheets has any function similar to Excel”s (or was it 123?) @cellpointer {RIGHT}. Grrrr. I’m just looking for a starting point as nothing I’ve tried has gotten me in the right direction.
The closest I’ve gotten is
=AND(countif($K$20:$R$512, $AL3), countif($K$20:$R$512, $AM3))
(Where AL3 = 1 and AM3 = 2) (repeated down in secondary table to capture count for each combination)
