Forum Discussion
Remove Specific Duplicate Row
Hi amitchandak
That article doesn't mention anything about removing select duplicates based on values in another column.
Summarize wouldn't work, I need to do this in Power Query because there are a lot more data transformations to do afterwards.
Could you not do it in two steps - before you remove duplicates, make some sort of calculated column that counts the instances of that row's value in the column you're doing the dupe check on, then make a conditional column that sees if the new column's more than 1 and your status is inactive, and use that to delete your inactive dupes first? Not particularly efficient, but it should work
edit - probably need to add in some condition to consider the situation where there's two rows and they're both inactive, but the general principle is the same