title: Excel find duplicate cells in multiple columns
body: <p>I have an Excel table with 4 columns and need to find the values that are the same in ALL 4 of the columns and put them aside. Trying to figure out how to accomplish this in Excel.</p>
  
  <p>Example:</p>
  
  <pre><code>Column 1    Column 2    Column 3    Column 4
  A1          B1          B1          A1
  B1          C2          C1          B1
  C2          D3          C2          C2
  </code></pre>
  
  <p>In this example, both <strong>B1</strong> and <strong>C2</strong> values comply and must be set aside.</p>