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