Delete Duplicate Rows?

Use the Remove Duplicates feature of Excel.

  1. Select your data.

  2. Click Remove Duplicates on the Data ribbon.

  3. Choose which columns to use as criteria for duplicate entries. In your case, it's one column, so just select the single column.

    enter image description here

  4. Click OK.

    enter image description here