Delete Duplicate Rows?

Question

I have a column in an Excel spreadsheet with several hundred entries, and some of these entries are duplicated.

I would like to remove all duplicate entries from the column so that each entry remaining is unique.

Is there a way to accomplish this automatically?

Answer 1

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.

   

4. Click OK.