IF range cells contains 2 same characters

Originally Posted by antis

Hi guys,

I have a problem with my formula here.
i want to find if a certain range have a 2 characters.
For example;
Range column A to F
The value 1 1 A B 1 A

Therefore in column G, i want to make a formula IF there are 2 "A" on Range A to F then G=1 else G=0

Is anyone can help me please. Thank you very much.

cheers

Hi and welcome to the board

try

=if(countif(a1:f1,"a")=2,1,0)

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.