Hi, My goal in this sample sheet is to delete the duplicate rows if the value is FAIL. The more complicated goal is to delete the duplicate rows if the value is FAIL and the first duplicate value is PASS. Thank you for any advance.
Hi, My goal in this sample sheet is to delete the duplicate rows if the value is FAIL. The more complicated goal is to delete the duplicate rows if the value is FAIL and the first duplicate value is PASS. Thank you for any advance.
Why not just use a helper column to identify duplicates then filter the range for the duplicates, decide which rows yo want to select and delete them.
e.g. in J2 copied down
=IF(AND(I2="FAIL",COUNTIF($F$2:$F$9,F2)>1),"Duplicate","")
Then filter on column J, select all rows and delete. Then remove the autofilter.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are 1000's of rows and while I can highlight the duplicates in groups. It can be a bit overwhelming to look at all duplicates each day. That is most likely what I will have to do.
I just tried Richard's suggestion and it seemed to do what is described in post #1.
If you have trouble applying the suggestion to your file then let us know where the problem occurs and we can try to help.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks