title: Ignore Duplicates and Create New List of Unique Values in Excel
body: <p>I have a column of values that often appear as duplicates. I need to create a new column, of unique values based on the first column, as follows:</p>
  
  <pre><code>Column A   Column B  
  a          a
  a          b
  b          c
  c
  c
  </code></pre>
  
  <p>This Column B will actually need to appear on a different sheet, within the same workbook, so I assume it will need to work with the <code>sheet2!A1</code> style format.</p>
  
  <p>I have not had any luck with the Data/Filter menu options as this only seems to work on command. I need column B to update automatically whenever a new value is entered into column A. </p>