Hi, I tried to explain this yesterday but did a horrible job and messed up the thread with other ideas. I made examples and hope I can explain what I need better.

My goal is every inspection that has PASS at some point, that row is deleted.

This spreadsheet is a small sample of what I'm working with https://www.dropbox.com/scl/fi/0yhgz...vky4m58pycmsur

Example1.PNG


This second example is where I have found the duplicates which are highlighted. https://www.dropbox.com/scl/fi/u45vv...rbl85z4nqczigq

In this image, you can see the duplicate convey#BC are highlighted with one being FAIL and one being PASS which means both these rows need to be deleted. Note: Some items can be inspected several times before getting a PASS. I can't do it manually because this sheet has 1000's of rows which I will go over a few times a week.

dup1.png

Once I have deleted all these duplicates with PASS in at least one row. I will delete all PASS items. Leaving only the truly failed items.

What do I need to learn to do this process?
Thank you for your time
Kim