1

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?

3
  • I'm voting to close this question as off-topic because it's not useful at all and shows up very high in searches. Feb 18, 2015 at 18:17
  • @fixer1234 closing as duplicate would redirect users that see it to a useful answer (rather than links only), though I didn't link a possible duplicate. Feb 19, 2015 at 12:53
  • @fixer1234 I've nominated it for reopening. We might want to redirect the others back to this one if it gets reopened. Feb 26, 2015 at 13:12

1 Answer 1

3

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

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .