title: Make a new column without duplicates VBA?
body: <p>I have a column of cells whose values are something like this:</p>
  
  <pre><code>a
  a
  b
  b
  c
  c
  c
  c
  d
  e
  f
  f
  </code></pre>
  
  <p>etc. </p>
  
  <p>I'm looking to take the non-duplicated values and paste them into a new column. My pseudocode for this is as follows:</p>
  
  <pre><code>ActiveSheet.Range("a1").End(xlDown).Select
  aend = Selection.Row
  for acol= 1 to aend
      ActiveSheet.Range("b1").End(xlDown).Select
      bend = Selection.Row
          'if Cells(1,acol).Value &lt;&gt; any of the values in the range Cells(2,1).Value
          'to Cells(2,bend).Value, then add the value of Cells(1,acol) to the end of 
          'column b.
  </code></pre>
  
  <p>Does my logic in this make sense? I'm not sure how to code the commented portion. If this isn't the most efficient way to do it, could someone suggest a better way? Thanks so much!</p>