One way (array-entered: CTRL-SHIFT-ENTER of CMD-RETURN):

=SUM(--(MID(A1,ROW(INDIRECT("1:" & LEN(A1))),1) =
MID(A2,ROW(INDIRECT("1:" & LEN(A1))),1)))


In article
,
streetfighter
wrote:

didnt know where to put this so i thought here would be best, basicaaly
i want to be able to compare 2 cells.

For example say i have one cell with 1111000111, and another with
1100111000 is it possible to get a result of 2.

Because
1111000111
1100111000
the first two letters are the same so there are 2 "correct" restults,
is there any code which i can put in for complicated versions of this,

thanks