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

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)

"ShamsulZ" wrote in message
...
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

Hi

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

--
Regards

Roger Govier


"ShamsulZ" wrote in message
...
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

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

"ShamsulZ" wrote:

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

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

"ShamsulZ" wrote in message
...
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

Very neat, David!!!

--
Regards

Roger Govier


"David F Cox" wrote in message
...
=MOD(RIGHT(A1,2), 11) = 0

"ShamsulZ" wrote in message
...
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