Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-25-2014
post by Simon LEFEUVRE (http://productforums.google.com/forum/?zx=tu8u6x37u114&usp=sheets_web#!mydiscussions/docs/vZ8Q0cF5ljc)
How to use COUNTIF with string containing "?" or "~"
In regard to handling wild card characters ? and * and the character ~ as literal characters one has to precede them with another ~ in the search string. In Simon's data I only noticed use of ~ character only -- and that is why I have addressed handling ~ as a literal character in the solution here. In case there are ? and * that have to handled as literals these can also be handled in a manner I have addressed the issue of ~.