title: Excel: Find duplicates in one column, then remove rows based on value in other column
body: <p>I've been able to find a number of articles that seem to orbit my particular puzzle, but I'm having difficulty carving out the specific solution for it. Using the below image for reference:</p>
  
  <pre><code>ID  Name      Company Name
   5  Dennis E  Lantz Boggio Architects, Pc
   6  Director  Lantz Boggio Architects, Pc
   7  Glenn D   Lantz Boggio Architects, Pc
   8  Director  Ge Johnson Construction
   9  Evan Da   GH Phipps Construction Companies
  10  Paul Fog  GH Phipps Construction Companies
  11  Todd W    GH Phipps Construction Companies
  </code></pre>
  
  <p>I have a mailing list that is organized so each unique contact is placed on an individual row. The list contains columns for Name (column A in my sheet) and Company Name (column B). </p>
  
  <p>If the Name cell was originally empty, a default 'generic' title is entered (e.g. 'Director', as per rows 6 and 8 in the image).</p>
  
  <p>In some cases, there are multiple contacts at the same company (e.g. rows 5-7, 9-11). Occasionally, one of those contacts has a 'generic' name (e.g. row 6).</p>
  
  <p>What I'd like to do:</p>
  
  <ul>
  <li>Search for duplicates in Column B</li>
  <li>Then delete the row based on the value in Column A (with me defining the specific values to be sought for)</li>
  </ul>
  
  <p>So in the example image, only row 6 would be deleted because Column B contains a duplicate address, and Column A contains the value 'Director'.</p>
  
  <p>Thank you!</p>