I am trying to do a if or statement with a multiple countif statement and im not sure if what I want to do is possible.
I have a comments column of text and I only want to pull out the text with certain key words. This is my formula at the moment =IF(OR(COUNTIF(B6,"*period*"),B6="*location*"),"true","false").
Please can some advise if there is any kind of solution to this. Many thanks
Bookmarks