I have several thousand rows that have data in the URL column in common.
I want to Remove Duplicates using data in this column to signify which row is a duplicate.
But data elsewhere in each row may be different.
While I want to remove duplicates based on that URL data, I also want to choose which rows to keep based on the contents of another cell.
How can I remove only the duplicate row that has 0 in the Paragraphs column?
View best response
This is can be done by using a formula in a helper column to identify the columns that you need to delete.
I suggest this formula:
=IF(COUNTIF($B$2:$B$10,B2)>1,IF(A2=0,"To be removed",""),"")
After that, you can sort the helper column from A to Z, then select the marked columns and delete them.
Hope that helps