Surendra Sharma

Surendra Sharma

Search This Blog

Tuesday, July 30, 2013

How to get distinct values from column in Excel

If you have repetitive entries in excel column as below


How to get distinct values from column in Excel sheet.


Solution:-

Select column and click on Data -> Remove Duplicates
You should get output as below




Please leave your comment if it’s useful for you.

1 comment:

  1. That's even better than my earlier suggestion. My apologies. I thought you were asking a question, which is why I replied.

    ReplyDelete