Why not use the "Remove Duplicates" option in the Data tab?
1.) Select the range of cells, or make sure that the active cell is in a table.
2.) On the Data tab, in the Data Tools group, click Remove Duplicates.
Do one or more of the following:
Under Columns, select one or more columns.
- To quickly select all columns, click Select All.
- To quickly clear all columns, click Unselect All.
3.) If the range of cells or table contains many columns and you want to only select a few columns, you may find it easier to click Unselect All, and then under Columns, select those columns.
4.) Click OK.
A message is displayed indicating how many duplicate values were removed and how many unique values remain, or if no duplicate values were removed.
5.) Click OK.