Comparing values with a cell

[Estherl]

I am comparing a string of numbers within a cell, and would like t
apply certain rules to the sequences of numbers.
How can I 'pick out' each digit in the number?

For example, I would like to compare the 1st digit with the 2nd, and i
they match (eg. 1,1 or 9,9), then I want the value to return '1' (fo
'1 matching pair').
So, basically I would like to compare 6 digits within each cell, an
distinguish whether they have matching pairs, triples, and quadruple
of numbers.

Any help would be appreicated

 

[Andy B]

Hi

You should be able to access each digit by using the MID function in a
formula:
=MID(A1,1,1) will give you the first digit
=MID(A1,2,1) will give you the second digit etc

 

[Estherl]

Thanks very much, that worked a treat! ;