W
Will
Dear Experts,
Which Formula shd I use so as to compute how many times a certain pair of
numbers appeared in a few groups of 6 numbers
example
1st group of 6 numbers: 2 (A1), 1 (B1), 7 (C1), 10 (D1), 8 (E1), 5 (F1)
2nd group of 6 numbers: 5 (A2), 10 (B2), 11 (C2), 12 (D2), 20 (E2), 1 (F2),
3rd group of 6numbers: 15 (A3), 10 (B3), 16 (C3), 17 (D3), 18 (E3), 1 (F3),
...
...
...
Number (5 & 10) appear: 2 times
Number (1 & 10) appear: 3 times
I tried to use countif but it only enable me to match a Single range with a
Single citeria but now i have multiple Range to match with 2 citeria.
Which Formula shd I use so as to compute how many times a certain pair of
numbers appeared in a few groups of 6 numbers
example
1st group of 6 numbers: 2 (A1), 1 (B1), 7 (C1), 10 (D1), 8 (E1), 5 (F1)
2nd group of 6 numbers: 5 (A2), 10 (B2), 11 (C2), 12 (D2), 20 (E2), 1 (F2),
3rd group of 6numbers: 15 (A3), 10 (B3), 16 (C3), 17 (D3), 18 (E3), 1 (F3),
...
...
...
Number (5 & 10) appear: 2 times
Number (1 & 10) appear: 3 times
I tried to use countif but it only enable me to match a Single range with a
Single citeria but now i have multiple Range to match with 2 citeria.