title: Excel - Remove duplicate row if column value is null
body: <p>If I have 3 rows in Microsoft Excel with the following data</p>
  
  <pre><code>id      name     address  
  id01    john     rundown avenu
  
  id02    bill     maptown drive
  
  id01    john     null
  </code></pre>
  
  <p>What is the easiest way to remove the third row because id01 already exist AND already has an address?  Formula or ribbon buttons...I don't care how.</p>
  
  <p>Thanks for any advice!</p>