title: VBA: Filter array based on another array
body: <p>I didn't find anything around. What I'm trying to achieve is to filter out an <code>[n x 3]</code> array based on another array <code>m x 1</code></p>
  
  <p>Let's say that:</p>
  
  <pre><code>arr1 = [n x 3] 'where n is roughly 500'000
  arr2 = [m x 1] 'where m is roughly 500
  </code></pre>
  
  <p><code>arr1</code> it's structured like this:</p>
  
  <pre><code>arr1(1,1) = ID1 | arr1(1,2) = String1 | arr1(1,3) = Bolean1
  arr1(2,1) = ID2 | arr1(2,2) = String2 | arr1(2,3) = Bolean2
  </code></pre>
  
  <p><code>arr2</code> it's structured like this:</p>
  
  <pre><code>arr2 (1) = ID2 | arr2 (2) = ID23 | arr2 (3) = ID345 | arr2 (4) = ID4567 | arr2 (5) = ID6381
  </code></pre>
  
  <p>What I need to do is filter <code>arr1</code> to exclude all those records where <code>arr1(i,1)</code> is included in <code>arr2</code> and <code>arr1(i,2) &lt;&gt; "String2"</code>. Then paste the filtered array onto a worksheet</p>