Forum Discussion
how to identify duplicates in one column based on a common value in another column?
For quite a while an automation was adding duplicate contacts to a Project, so a person is named sometimes many times on a Project. I need to delete the duplicates (shown below in bold). I have a tw...
Back up your file before trying.
Select/highlight your table.
Click Data, Remove Duplicates.
Check the boxes for the columns that contain project name and person name (uncheck any others).
Click OK.
Select/highlight your table.
Click Data, Remove Duplicates.
Check the boxes for the columns that contain project name and person name (uncheck any others).
Click OK.