title: Comparing Multiple Lists of Data in Excel to Find Correlating Data
body: <p>I thought I knew where to start with this but sadly I it's been long enough to where I need some assistance. First of all what I am working with is four lists of product data that I need to compare against my own product data.</p>
  
  <p>So for example each of the product lists contain the following data:</p>
  
  <pre><code>Product Category
  Product Name
  Inventory
  Product Price
  </code></pre>
  
  <p>Each of the lists have at least a thousand records.</p>
  
  <p>What I need is a fifth list that tells me which of the competitors products I don't have on my list.</p>
  
  <p>Last but not least and where this gets trickier is that the inventory contains duplicate records.</p>
  
  <p>Its hard for me even to construct this question as I spend time with it.</p>
  
  <p>What I want though is a list of products that are shared by all of the competitors that I do NOT have on my product list.</p>