By the way, this is flawed logic:
Quote Originally Posted by p45cal View Post
if you have a sequence like 10-12-14-16-18 in a cell in column G, there's no need to look for matches in any column K cells in the sheet above those beginning 10-.
You could for example find a three-number match in 1-10-12-14-18, which comes way before 10-?-?-?-?

This next bit seems to hold though:
Quote Originally Posted by p45cal View Post
If you're looking for 3 number matches or more, there's no need to look below cells in column K starting with the third largest value which is 14-.
but I didn't use it because stopping the search when 4500 3- and 4- number matches had been found was both easier to code and quicker.