Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
I'm voting to close this question as off-topic because it's not useful at all and shows up very high in searches. –  Raystafarian Feb 18 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. –  Raystafarian Feb 19 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. –  Raystafarian Feb 26 at 13:12

1 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.

    enter image description here

  4. Click OK.

    enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.