Seaching for 2 digits from a string against a list of numbers

[Sweetypie]

I have a list of numbers in One column, say Column A
In another column, say Column C I have s string ---3, 4, 5, 6, 7,or 8 digits long.

I want to identify all values in Column A that have 2 digits ONLY from the string.

Example
Column A
511
060
516
098
124
700
236
464

Column C (the string to be tested)
013689

Results shown in Column B
060
516
236


Notice that 098 does not qualify because all 3 digits are in the string. We only need those numbers that have 2 digits from the string.

[Sweetypie]

Why is 060 an acceptable result if the 0 is repeated... and not 700 or 511?

Thanks for reply. I should have anticipated that question. I am looking to identify 2 different digits from the string. So 060 is comprised of 2 different digits from the string even though 1 digit is repeated.

511 has only 1 of the relevant digits even though that 1 digit is repeated.

Hope it can be done.

[martindwilson]

this works for your sample but only if no digits repeated in your string in c(well it's in b1 of this)

[NBVC]

As long as you are consistently looking at 3-digit codes, then perhaps with 1 helper column...

Also, start the codes in row 2, so in B2 enter:

Please Login or Register  to view this content.

copied down.. where C1 contains the 013689 number.

then in C2:

Please Login or Register  to view this content.

copied down as far as necessary.


Adjust all ranges to suit.