Hello LordCrimsonKing and Welcome to Excel Forum.
Thank You for changing the title.
Perhaps this will be of help depending on how closely the actual data resembles the .jpg in post #1.
A column (E) is added that will attempt to identify those rows that should not be included in the final list using:
Formula:
=AND(COUNTIFS(A$2:A$8,A2,B$2:B$8,B2)>1,COUNTIFS(A$2:A2,A2,B$2:B2,B2)<=2,OR(SUM(C1,C2)=0,SUM(C2,C3)=0))
A table of data that meets the criteria (H:J) is populated using:
Formula:
=IFERROR(INDEX(A$2:A$8,AGGREGATE(15,6,(ROW($2:$8)-1)/($E$2:$E$8=FALSE),ROW(1:1))),"")
For future reference please upload a sample of your data (not a picture) by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Bookmarks