Searching through data with multiple conditions VBA/Excel -

i have list of data columns indicating test product went under , product. each product undergoes several tests example (hot medium cold). if can imagine, data specific product may

          b hot      product1 medium   product1 cold     product1 

i have many products under went testing spreadsheet extensive (a400 = cold, b400 = productx). trying see if each product underwent hot medium , cold testing. made additional column eliminate repeated product listing , search spreadsheet , find tests (no success). end goal create additional column parts did not go through of testing.

make 4 new columns these formulas

c: countifs(b:b,$a1,a:a,"hot")

d: countifs(b:b,$a1,a:a,"medium")

e: countifs(b:b,$a1,a:a,"cold")

these show how many times each of products has been tested in respective category. then, use in last column:

f: if(and($c1>0,$d1>0,$e1>0,"",$b1)

this account items tested in more once. if had category not tested in, show product name. there might multiple values in column.

edit: if absolutely had have 1 column, combine these superformula.