If you are using Microsoft Office Suite you will have a bit of an advantage because there is a built in feature for finding and deleting duplicates.
STEP1: Begin by selecting the cells you want to target for your search. In this case, we will
select the entire table by pressing “Control” and “A” at the same time (Ctrl + A).
STEP2: Once you have successfully selected the table, you will need to click on the “Data”
tab on the top of the screen and then select the “Remove Duplicates” function as
STEP3: Once you have clicked on it, a small dialog box will appear. You will notice that the
first row has automatically been deselected. The reason for this is that the “My data
has headers” box is ticked.
STEP4: In this case, we do not have any headers since the table starts at “Row 1.” We will
deselect the “My data has headers” box. Once you have done that, you will notice
that the whole table has been highlighted again and the “Columns” section changed
from “duplicates” to “Column A, B, and C.”
STEP5: Now that the entire table is selected, you just press the “OK” button to delete all
duplicates. In this case, all the rows with duplicate information except for one have
been deleted and the details of the deletion are displayed in the popup dialog box.