Hi Deciog,

My apologies on saying that the formula works perfect as I did not evaluate against duplicate numbers. I just did some random number entries and it does not provide a correct answer of "No" when the number is a duplicate, however the any order part is working properly so don’t change that part of the formula.

As an example:

Draw 4 =1213. The ones are duplicate numbers, so the formula should only provide a “Yes” if it finds all four numbers in any order, (e.g. is must find two (1)’s) to answer correctly, otherwise the result is No).

Solution #8 in cell D10 is __3__46__112__; hence a “YES” result is provided because the formula finds all 4 numbers from the Draw 4 in cell E10 “1213” in any order of the solution number.

However, Solution#9 in cell D11 is 33__213__; it provides a “Yes”, but this is incorrect because the solution number does not contain two ‘1’s as a match to the Draw 4 in cell E11. It does contain 3 of 4 numbers from the solution number in cell E11 (e.g. 2, 1, 3) I think the formula is seeing the number “1” and since it is there it gives the yes, but it should be looking for two number “1’s. Therefore only cell G10 would result in a “Yes”.

As an example:

Draw 3 =121. The ones are duplicate numbers, so the formula should only provide a “Yes” if it finds all three numbers in any order, (e.g. is must find two (1)’s) to answer correctly, otherwise the result is No).

Solution#5 in cell J7 is __211__99 and Solution#8 in cell J10 is 346__112__; hence a “YES” result is provided in cells M7 and M10 because the formula finds all 3 numbers from the Draw 3 “121” in any order of the solution number.

However, Solution#6 in cell J8 is 4__12__5 and Solution#9 in cell J11 is 33__21__3; it provides a “Yes”, for both, but this is incorrect, because neither solution number has two ‘1’s as a match to the Draw 3 in cells K8 or K11. Both solution numbers only contain 2 of 3 numbers from cells K8 or K11 (e.g. 2, 1). I think the formula is seeing the number “1” and since it is there it gives the yes, but it should be looking for two number “1’s. Therefore only cells M7 and M10 would result in a “Yes”.

Sample file attached to illustrate the issue.