title: How to combine special rows of two worksheets in one worsheet?
body: <p>In excel I have two worksheets. The first worksheet is like follows:</p>
  
  <pre><code>1   1
  2   0
  3   0
  4   0
  5   0
  6   0
  7   0
  8   0
  9   0
  10  1
  </code></pre>
  
  <p>and the second worksheet is like follows:</p>
  
  <pre><code>1   1
  2   0
  3   0
  4   0
  9   1
  10  1
  11  0
  12  0
  13  1
  14  0
  </code></pre>
  
  <p>(they do not necessarily contain the same number of elements). The first column is some ID (which might differ in the worksheets) and the second column is a flag whether to take this element in the combined worksheet.  The combined worksheet should look like:</p>
  
  <pre><code>1
  9
  10
  13
  </code></pre>
  
  <p>i.e, this worksheet contains only those elements which have a '1' in any of the other two worksheets (second column). </p>
  
  <p>How can I achieve this WITHOUT MACRO? Is there a solution?</p>