Spreadsheet: 816365d1675542710-count-set-of-comma-separated-values-within-another-paired-columns-test-count-set-of-value
Sheet: Sheet1

y/n | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z |  |  | range_ref | range | pairs | result | expected result
y | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2 |  |  |  | a | 18 |  | 3
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0 |  |  |  | a | 20 |  | 3
y | 10 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2 |  |  |  | a | 10 |  | 1
n | 12 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  | a | 12 |  | 0
y | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0 |  |  |  | a | 15 |  | 2
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  | a | 8 |  | 0
y | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  | a | 14 |  | 2
n | 18 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  | a | 24 |  | 2
n | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2 |  |  |  | a | 22 |  | 2
y | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2 |  |  |  | b,c,f | 2,2,2 |  | 3
y | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22 |  |  |  | b,c,f | 2,2,0 |  | 6
y | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2 |  |  |  | b,c,f | 2,0,2 |  | 1
y | 20 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22 |  |  |  | b,c,f | 2,0,22 |  | 2
y | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22 |  |  |  | b,c,f | 2,2,22 |  | 1
n | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2 |  |  |  | b,c,f | 2,0,0 |  | 2
y | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0 |  |  |  | e,w | 0,2 |  | 7
y | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0 |  |  |  | e,w | 0,1 |  | 7
y | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0 |  |  |  | e,w | 0,3 |  | 1
y | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0 |  |  |  | d,f,g,h,i | 3,2,1,2,1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 2,0,0,2,1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 222,2,1,2,1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 3,0,0,0,1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 2,0,0,0,1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 22,0,0,0,1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 22,2,1,0,1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 3,2,1,0,1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 22,22,2,2,2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 222,22,2,2,2 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 0,0,0,0,1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 0,0,0,2,2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d,f,g,h,i | 0,0,0,3,2 |  | 1