title: Find a duplicate in multiple cells with condition in Google Sheets
body: <p>I have column <strong>Name</strong> with different <strong>Type</strong> (Low, Medium, High).</p>
  
  <p>Then I have multiple columns <strong>Name</strong> and need to check whether there is a duplicate and their Types are not <strong>Low</strong>, and return the duplicated Cells.</p>
  
  <p>Example sheet: <a href="https://docs.google.com/spreadsheets/d/12gazwAY-yZ7LFzVd_fqv6vKRrwOav_9D5C-ujlGufmw/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/12gazwAY-yZ7LFzVd_fqv6vKRrwOav_9D5C-ujlGufmw/edit#gid=0</a></p>