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" <(E-Mail Removed)> wrote in message
news:FEE9DE13-F1A2-4954-B0B7-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:FEE9DE13-F1A2-4954-B0B7-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:FEE9DE13-F1A2-4954-B0B7-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =MOD(RIGHT(A1,2), 11) = 0
>
> "ShamsulZ" <(E-Mail Removed)> wrote in message
> news:FEE9DE13-F1A2-4954-B0B7-(E-Mail Removed)...
>> 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
>>
>
>