title: Check for unique keywords in cell data in google sheet
body: <p>I have a list of email subject lines with job roles on the left side, need to filter out roles like Assistant Manager, Manager, Civil Engineer, Project Manager to get the result.</p>
  <p>Certain cells don't have the job role mentioned so to be left blank</p>
  <p>The rows on the sheet need to remain intact so data can be analysed.</p>
  <p>i tried using REGEXMATCH but it will not work for row5
  is there a way to have a single formula, which includes all keywords  for the whole list.</p>
  <p><code>REGEXMATCH(B3, &quot;assistant|manager&quot;)</code></p>
  <p>I'm doing this on Google sheet and have shared the screenshot and the GoogleSheet file <a href="https://docs.google.com/spreadsheets/d/1CUXXqXzvPYrJsHYV1nbk3b5hn6wF-rofa12zE1iEI5Q/edit?usp=sharing" rel="nofollow noreferrer">Link</a>  for reference.</p>
  <p><a href="https://i.stack.imgur.com/VX5iL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VX5iL.png" alt="enter image description here" /></a></p>