how to identify only 2 digit permuted number from list of 3 digit number

Sorry ppl for the earlier username,it was an innocent one didnt mean to offend u;ll.

Hi if anyone could help me with ways to how to identify only 2 digit permuted number from list of 3 digit number using excel .

Let say we have this set of number (2 Digit) number 35,23,54,44 and (3 digit) number 135,253,145,445.

I need a formula to identify or track if the 2 digit numbers(each one of that 2 digit) is in the 3digit number.

For example
35 is in 235 and 253 (note that digit 3,digit 5 can be in anywhere in that specific 3 digit number)

Same goes to

23 is in 253

54 is in 145

44 is in 445


Thank you


PS:Hope Stan can help me again.Thank you.

what you want as result?

Originally Posted by zbor

what you want as result?

Thanks zbor for your reply, i want the use the same spreadsheet that i attached but this time i want to identify only 2 numbers.

Thanks

Try look here:

Originally Posted by zbor

Try look here:

Thanks zbor for your reply.Actually i wanted to indentify in a number for example(345),two specified digit i want example the (digit 3 and 5)

Some example are

216 got two specified digit i want 2 and 6
254 got two specified digit i want 2 and 4

Example in the formula if i find for 26 or 62 i get the answer 216 and not 254
Same goes to if i find 24 or 42 i get answer 254 not 216.

Thank you
.