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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]H?eLlo?[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Good?night[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]Goodmorning??[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]?Goodevening[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]B??ye[/TD]
[TD]True[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!