Quote Originally Posted by Paul_Hossler View Post
OK, I'm still confused
If Col K consists of all 324,632 combinations from 1-2-3-4-5 to 31-32-33-34-35, it would seem that ANY Col G will have a match since G's 5 numbers will be guaranteed to be in Col K
I had a similar question a few messages ago:
Quote Originally Posted by p45cal View Post
Is there any point in highlighting cells in column G? There always going to match something (well, 4501 matches to be exact, in the case of 3-,4- and 5-number matches).
and I droned on about it possibly being to record that the cell had been processed.
Certainly, it would be a help to know what the aims of the OP are - I have asked, twice, but haven't yet had a proper answer.





Quote Originally Posted by Paul_Hossler View Post
OR
Is it to 'fill in' more Col K entries with the 3 and 4's?
I wish I knew…




Quote Originally Posted by Paul_Hossler View Post
So a G = "10-20-30-31-32" would 'fill in' Col K all triplets that can be made of the 5 G pieces, e.g. any K with

10, 20, and 30 somewhere in it
10, 20, and 31 somewhere in it
10, 20, and 32 somewhere in it
20, 30, and 31 somewhere in it
20, 30, and 32 somewhere in it
30, 31, and 32 somewhere in it
along with (I think) the non-contiguous values:
10,30,31
10,30,32
10,31,32
20,31,32
for the triplets[, and
10,20,30,31
10,20,30,32
10,20,31,32
10,30,31,32
20,30,31,32
for the quadruplets.]
Your code already handles that admirably.