Find Duplicate rows and delete if. (asking again with examples)

**Kimbersh** · 01-30-2021, 04:45 PM

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

**AliGW** · 01-30-2021, 06:02 PM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...e-only-if.html