Another approach, using VBA:
Sub tst()
For Each cl In Columns(1).SpecialCells(2)
c01 = c01 & "|" & vbCr & "|" & Join(Application.Transpose(Application.Transpose(cl.Resize(, 15))), "|")
Next
sq = Split(c01, vbCr)
x1 = UBound(Filter(Filter(Filter(sq, "|06|"), "|10|"), "|23|")) + 1
x2 = UBound(Filter(Filter(Filter(sq, "|09|"), "|19|"), "|20|")) + 1
x3 = UBound(Filter(Filter(Filter(sq, "|01|"), "|16|"), "|25|")) + 1
x4 = UBound(Filter(Filter(Filter(sq, "|02|"), "|07|"), "|10|")) + 1
x5 = UBound(Filter(Filter(Filter(sq, "|04|"), "|09|"), "|12|")) + 1
x7 = UBound(Filter(Filter(Filter(Filter(Filter(Filter(Filter(sq, "|04|"), "|09|"), "|12|"), "|16|"), "|18|"), "|20|"), "25|")) + 1
End Sub
In x1...x5 the frequency of the respective combinations.
In x7 an example how to use this method with a combination of 7 numbers
Bookmarks