title: Macro that deletes duplicates given particular parameters
body: <p>Let's say I am given a data sheet with executed trades. The problem is that each trade is given a buy side and a sell side which duplicates the information I want to analyze. The commonality amongst the duplicates is that they have the same order number. Example:</p>
  
  <pre><code>**Order Number**       **Side**
  20                       Buy
  20                       Sell
  25                       Buy
  30                       Sell
  30                       Buy
  25                       Sell
  </code></pre>
  
  <p>Initially I thought of using "Remove Duplicates" but that does not delete the entire row and rather just the cell. How can I create a macro that Searches the order number column for duplicates and if they are found --> one row is deleted?</p>