title: VBA - Adding unique values to existing array
body: <p>Suppose I have two separate columns/arrays.</p>
  
  <p>Column A have 100 rows, each with 20-length string</p>
  
  <p>A(1)=daskjdkjasdj</p>
  
  <p>A(2)=asdsadgggggg</p>
  
  <p>A(3)=dsadpoeeeeee</p>
  
  <p>Column B is a column with 200 rows, some of the rows have the same values as mentioned above, I would like to add unique one. 
  I want to add new identifier only if it is not part of column A.
  (I forgot to mention that for each row with identifier there are 20 other columns with data that should be also added. My apologies)</p>
  
  <p><img src="https://i.stack.imgur.com/kzbOX.png" alt="sample data"></p>
  
  <p>I want to add to data A rows from Data B where identifier is not in data A.
  As result i would get </p>
  
  <p><img src="https://i.stack.imgur.com/DvzZV.png" alt="new data a"></p>
  
  <p>I was doing it with simply:</p>
  
  <pre><code>for i = 1 to lastrow_column_b
      g=0
      for j=1 to ubound(column_a)
          if column_a(j)=cells(i) then g=1
          goto skip
      next
      skip:
      if g = 0 then "do something, add to column_a"
  next
  </code></pre>
  
  <p>But i believe there is more efficient way for doing that</p>