Request = separate pairs with repeating digits.

[piter]

Request = separate pairs with repeating digits
Ex = 01 21 = yes
01 32 = no
The repeat can have 2 or 3 repeated digits
The list has more than 4 thousand formations

 

[wideboydixon]

Book1
	A	B
1	01 21	yes
2	01 32	no
Sheet1

Cell Formulas
Range	Formula
B1	=IF(SUMPRODUCT(--(LEN($A1)-LEN(SUBSTITUTE($A1,ROW($A$1:$A$10)-1,""))>1))>0,"yes","no")

WBD

 

[piter]

http://www.mediafire.com/file/oqcz4s80x5oyogu/duques_ka.xlsx

 

[piter]

Hello, wideboy, please get on the spreadsheet, that is activate the formula I'm not aware of excel, I'm a truck driver

 

[wideboydixon]

Book1
	A	B	C
1	01	02	yes
2	01	03	yes
3	01	04	yes
4	01	05	yes
5	01	06	yes
6	01	07	yes
7	01	08	yes
8	01	09	yes
9	01	20	yes
10	01	30	yes
11	01	40	yes
12	01	50	yes
13	01	60	yes
14	01	70	yes
15	01	80	yes
16	01	79	no
17	01	69	no
18	01	59	no
19	01	49	no
20	01	39	no
21	01	29	no
22	01	19	yes
Planilha1

Cell Formulas
Range	Formula
C1	=IF(SUMPRODUCT(--(LEN(TEXT($A1,"00")&TEXT($B1,"00"))-LEN(SUBSTITUTE(TEXT($A1,"00")&TEXT($B1,"00"),ROW($A$1:$A$10)-1,""))>1))>0,"yes","no")

WBD

 

[piter]

hello WIDEBOY, thank you!conglatulations