Searching through data with multiple conditions VBA/Excel
<p>I have a list of data with columns indicating the test a product went under and the product. Each product undergoes several tests for example (hot medium cold). If you can imagine, the data for a specific product may look like </p>

<pre><code> A          B
hot      product1
medium   product1
cold     product1
</code></pre>

<p>I have many products that under went testing so the spreadsheet is extensive (A400 = cold, B400 = productX). What I am trying to do is see if each product underwent the hot medium and cold testing. I made an additional column to eliminate repeated product listing and search the spreadsheet and find the tests (no success). The end goal is to create an additional column with all the parts that did not go through all of the testing.</p>

<p><a href="https://i.stack.imgur.com/3MqMM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3MqMM.png" alt="Example"></a></p>