detect only when number is in the same position in each of the two sectors (yellow color),

[jorel]

detect only when number is in the same position in each of the two sectors (yellow color), forming the double,
objective is to locate only the doubles of numbers in each position, when there is only one number in the same position in the two sectors it will be ignored,
only, the doublet in the same position in the two sectors
https://www.excelforum.com/attachmen...1&d=1616509312

[Bo_Ry]

Please try at
Q5
=REPT("x",COUNTIFS($A5:$O5,Q$4))

AM5
=REPT(Q$4&"."&AB$4,Q5&AB5="xx")

[jorel]

hello,BO_RY,perfect, conglatulations, thank you!!