CF highlighting single number from set combination !

[serge]

Hi,
I'm looking for a CF formula in column R that will return in the whole set combination when 1 number or more are out of the range table from T9:X10 in their respecting position ?

This will help me to reduce significantly my set combinations.

I hope I'm clear enough ?

In R5 : =Index2Combin(A$2,A$1,P5)

Thank you.

 

[serge]

Is it possible to use a CF formula with this Index formula in R5 : =Index2Combin(A$2,A$1,P5) ?

 

[serge]

Hi,

I really need this CF, few of you looked at it but no response, maybe because it's not possible ? can someone just respond and tell me if it is possible or not then I will let it go and try a different way.
Thank you.