In Microsoft Excel 2010, it is very easy to sort a column by unique records only.
Sort a column by unique records only in Excel 2010
Here are the steps:
You will need to make a column header. In my example, I simply typed “Header”, in cell A1.
Click on the column you want to sort, in my example I clicked on Column A.
Click on the Data Tab and then click “Advanced”.
Check the box that says, “Unique Records Only.”
Congrats, your column is now sorted by only unique records.