I would like to find some function or VBA code to count how many rows contain 3 specific numbers in columns B: to G:
i.e how many rows contain 1 & 2 & 7
<tbody>
</tbody>
i.e how many rows contain 1 & 2 & 7
A | B | C | D | E | F | G | |
1 | David | 1 | 4 | 7 | 8 | 9 | 10 |
2 | Andrew | 1 | 2 | 4 | 5 | 7 | 9 |
3 | Steve | 2 | 3 | 4 | 6 | 8 | 10 |
4 | Bob | 3 | 5 | 6 | 7 | 9 | 10 |
5 | Harry | 1 | 4 | 6 | 7 | 8 | 9 |
6 | John | 2 | 4 | 5 | 6 | 7 | 8 |
7 | Luke | 3 | 4 | 6 | 7 | 8 | 9 |
<tbody>
</tbody>