title: Create list without duplicates automatically
body: <p>I have the following Excel spreadsheet</p>
  
  <pre><code>           A            B
  1         ID           Unique ID
  2         27152        27152             
  3         27152        29297
  4         27152        28802
  5         29297
  6         29297
  7         28802
  8         28802
  9         28802
  10        28802
  </code></pre>
  
  <p>In <strong>Column A</strong> you can find different Product IDs. 
  They can appear <em>several</em> times in <strong>Column A</strong>.</p>
  
  <p>In <strong>Column B</strong> I want to make a list without the duplicates so 
  it shows the unique IDs from the list in <strong>Column A</strong>.</p>
  
  <p>I know I can achieve this by using either the "Advanced Filter" or by the "Remove Duplicate" function unter the tab data tools.</p>
  
  <p>However, I would prefer to create the list in <strong>Column B</strong> without these options since the database in <strong>Column A</strong> will be updated on a regular basis; therefore, it would be better if the multiple values are deleted automatically by a formula in <strong>Column B</strong>.</p>
  
  <p>I was trying to solve it with the AGGREGATE function but could not make it work.</p>
  
  <pre><code>B2 =AGGREGATE(14,6,A$2:A$10,1)
  B3 =AGGREGATE(14,6,A$2:A$10,2)
  B4 =AGGREGATE(14,6,A$2:A$10,3)
  </code></pre>
  
  <p><em>Since it should be user-friendly and easy in the handling I would prefer a solution without any array formula or an additional Column that needs to be inserted.</em></p>