hi all

does any one know how to count how many cell in a row that contain certain combination from a larger combination

example: i have this combination: 1 2 3 4 5 6

in hundreds or thousands of cells in a row i have combinations such

1 2 3 4 5 6 7
1 2 3 4 5 6 8
1 2 3 4 5 6 9
1 2 3 4 5 6 10
1 2 3 4 5 7 8
1 2 3 4 5 7 9
1 2 3 4 5 7 10 etc

i we know here that i have 4 cells that contain 1 2 3 4 5 6, but the problem is have thousands of cells to check, and not in ascending order like in the example where i can sort them

and another example: i have this combination 1 4 7 9

and in hundreds or thousands of cells in a row i have combinations such:

1 2 5 8 12 13
1 4 7 9 10 12
1 2 3 4 7 9
1 3 4 6 7 9
1 4 7 8 9 10
in this example i have 4 cells that contain 1 4 7 9

kind regards