title: Delete an entire row if the term in the first and second column are duplicated below but leave one
body: <p>I’m currently having an issue which I don’t think i can resolve.
  I have a table in excel with multiple titles such as “Promoter”, “Account”, “#order”, “Date” &amp; “City” with thousands of rows in it.
  I just want to know if there is a VBA code to delete specific rows with duplicated values if those were to appear in 2 columns (A and B)
  Such as if the “Account” and the “Promoter” are the same in many other rows, i just want to delete the duplicates and leave one for accounting purposes.</p>
  <p>Example:</p>
  <p><strong>Data</strong></p>
  <pre><code>0987:Raymond:ORD-27:NY
  
  1256:Hannah :ORD-99:MI
  
  1345:André  :ORD-45:WI
  
  1866:Darryl :ORD-02:WA
  
  6419:John.  :ORD-22:CA
  
  0987:Raymond:ORD-87:MN
  
  0987:Raymond:ORD-24:CO
  </code></pre>
  <p><code>Result:</code></p>
  <pre><code>1256:Hannah :ORD-99:MI
  
  1345:André  :ORD-45:WI
  
  1866:Darryl :ORD-02:WA
  
  6419:John.  :ORD-22:CA
  
  0987:Raymond:ORD-87:MN
  </code></pre>
  <p>Because the “account” (09087) and the “Promoter” (Raymond) are repeated in the rows below even though the order and the state are different, i just want to delete the duplicates that fall in that category (Same account and Promoter) and keep one because the orders belong to the same account. There are several “promoters” to consider, that’s why I don’t know how to proceed.</p>
  <p>Thank you very much for your help i will appreciate every answer.</p>