Delete both duplicates rows

Copper Contributor

I know how to delete duplicates in Excel. However, my issue is that when locating a duplicate, I want to delete BOTH rows... the original AND the duplicate. Does anyone know how this might be accomplished?

 

Thanks, Chris 

0 Replies