IF range cells contains 2 same characters

thx arthur,

it works. However, I still counter a problem here.

For example.
Colum A to J
Value 1 1 1 a 1 1 b 1 1 a

Then If I use your formula, it works. However, then I want to change value "a" to "1" if within that range have 2 "A"

Is it possible?

Thank you.

Do you want to test : if there are two "a" or two"b" then G =1?

Hi, Only if there are 2 "a", then I want to change "a" to 1 within that that range. Not G. G = 1 or 0 only.
Could we do this kind of things?

thank you.