Forum Discussion
Solved
How do I choose which row to keep in Remove Duplicates?
Hiya. 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 elsewher...
Hi,
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
Hi,
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
It's impossible that this answer can be bettered.
Thank you so much for taking the time to answer. It's greatly appreciated.
Thank you so much for taking the time to answer. It's greatly appreciated.