Detect double digit

[Guest]

I'm looking for a formula that enable me to detect any no. of last 2 digit
that is the same for e.g 1233, abcd2345677, 90566 etc. Thanks for your help

 

[Bob Phillips]

Are you looking for its position in the string? This gives the first
position of the first pair in the string

=MIN(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1)-1)),1)=MID(A1,ROW(INDIRECT("2:"&LEN
(A1))),1),ROW(INDIRECT("1:"&LEN(A1)-1))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

I'm looking for a formula that enable me to detect any no. of last 2 digit
that is the same for e.g 1233, abcd2345677, 90566 etc. Thanks for your

help

 

[Roger Govier]

Hi

Try
=IF(LEN(A1)<2,"",MID(A1,LEN(A1)-1,1)=RIGHT(A1))

 

[Guest]

Hi Shamsulz

it depends on how you want to mark your digits, but you can decide that for
yourself.

i would do something like this:

if right(YourDigit,1) = left(right(YourDigit,2),1) then
'Do Something
end if

and YourDigit would be a variable or even a cell.

if you don't like VBA you could do it like this as a cell-formula

if(right(A1,1) = left(right(A1,2),1);"Double Digit detected"; "")

hth

Cheers Carlo

 

[David F Cox]

=MOD(RIGHT(A1,2), 11) = 0

 

[Roger Govier]

Very neat, David!!!

--
Regards

Roger Govier

=MOD(RIGHT(A1,2), 11) = 0