=COUNTIFS(range,"tru?",range,"?rue"). Personally I am not satisfied with this formula but it gives the desired result. My issue is there are several hundreds titles in the and I am trying to find duplicates. So title "True" is just one of many and it defeats the purpose of formula, if I have to deal in a cumbersome way like this.