Create a list of unique entries that did not meet a specific criteria

Will using the auto filter create what you are looking for?

http://www.wikihow.com/Use-AutoFilter-in-MS-Excel
ba
If this is what you are looking for and need it automated, this can be accomplished with VBA

as an alternative, maybe this formula approach?

Create a helper on your 2nd table (I used AA), you can hide this if you want. then in AA15 (in your sample, I used this, copied down...
=IF(AND(I15="no",COUNTIFS($C$15:C15,C15,$L$15:L15,L15,$E$15:E15,E15)=1),AA14+1,AA14)

THen to extract the data, in your 1st (top) table,use this, copied down and across...
=IFERROR(INDEX($C$14:$Z$49,MATCH(ROW($A1),$AA$14:$AA$49,0),MATCH(W$2,$C$14:$Z$14,0)),"")

Originally Posted by FDibbins

as an alternative, maybe this formula approach?

Create a helper on your 2nd table (I used AA), you can hide this if you want. then in AA15 (in your sample, I used this, copied down...
=IF(AND(I15="no",COUNTIFS($C$15:C15,C15,$L$15:L15,L15,$E$15:E15,E15)=1),AA14+1,AA14)

THen to extract the data, in your 1st (top) table,use this, copied down and across...
=IFERROR(INDEX($C$14:$Z$49,MATCH(ROW($A1),$AA$14:$AA$49,0),MATCH(W$2,$C$14:$Z$14,0)),"")

I was able to figure out how integrate your formula into my spreadsheet so it works!!!

Thanks for your help!!!!
Joanne

Happy to help and thanks for the feedback