Excel formula to look for '??' or 2 seperate '?' characters

[Roy_Excel_Island_Apps]

Hi guys,

anyone who knows a formula to give a true/false output if cells countain double question marks or two seperate questions marks?

This should be the result:

H?eLlo?	True
Good?night	False
Goodmorning??	True
?Goodevening	False
B??ye	True

<tbody>
</tbody>

 

[Scott Huish]

If there are more than 2 i get true. The opening post said 2 not more than 2 didnt it?

It doesn't actually say not more than 2, just that it contains 2, that doesn't necessarily mean that it couldn't contain 3.

 

[steve the fish]

Ok I didn't read it like that but not to worry.

 

[Roy_Excel_Island_Apps]

=len(a1)-len(substitute(a1,"?",""))=2

Thanks! This formula works!

 

[Roy_Excel_Island_Apps]

=if(len(a2) -2 = len(substitute(a2,"?","")),true,false)

Thanks! This one works as well!

 

[Roy_Excel_Island_Apps]

Strange, works perfectly for me
Try adding an extra asterisk =ISNUMBER(MATCH("*~?*~?*",B2,0))

Juuup, like this it works just fine! Thanks!