Comparing characters

I am going to try and explain this as best I can.

I have 9 values i need to compare. They each contain a string of numbers from 1-9. So 123, 1234, 1345, 14689 and so on. They will never contain more of the same number, and will always be from lowest to highest. I need to compare value one to the other values, then value 2 against the other values, then value 3 and 4 all the way to 9. there will be 9 total. I need it to count how many of each character from a certain value, can be found in each of the other values.

So far I think i have the logic down, but I don't know an efficient way to code it.

Compare 257 against 35678

They both have a 5, and a 7. This is a match.

Maybe I can clarify, let's say we have 9 values. The first value we look at is 123. i want to check the other 8 values and see if they contain 1 and 2 or 1 and 3 or 2 and 3.

Sorry i need this done in VBA, i don't want any helper cells. Excel is only being used as a GUI

The issues i don't know what function to use. I need it to count each possible 2 digit number in each other cell.

it will always be 9 cells total. cell 1 has 123456789.... i want it to count 12, 13, 14, 15, 16, 17, 18, 19, 23, 24 ,25, 26, 27, 28, 29,34,35,36,37,38,39,45,46,47,48,49,56,57,58,59,67,68,69,78,79,89

so really i need to know how to get it to loop for each possible combination and return the total amount of that number in a range