title: Remove ALL duplicates from column A in Excel
body: <p>I am looking for a macro that can remove ALL duplicates from column A.</p>
  
  <p>Input:</p>
  
  <pre><code>John
  Jimmy
  Brenda
  Brenda
  Tom
  Tom
  Todd
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>John
  Jimmy
  Todd
  </code></pre>
  
  <p>I am working with a large set of data, and Excel isn't cooperating. Can't seem to find a solution online that works. </p>
  
  <p>Thanks! </p>