Excel 2010 Sort by Unique Records Only

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:

Step 1

You will need to make a column header. In my example, I simply typed “Header”, in cell A1.

Excel 2010 - Column Header

Step 2

Click on the column you want to sort, in my example I clicked on Column A.

Excel 2010 - Column Sort

Step 3

Click on the Data Tab and then click “Advanced”.

Excel 2010 - Data Advanced

Step 4

Check the box that says, “Unique Records Only.”

Excel 2010 - Unique Records Only

Congrats, your column is now sorted by only unique records.

Excel 2010 - Sorted Column

You may also like:

Outlook 2010 Delete Meeting – No Email Delete Meeting in Outlook If you create/setup a meeting in Outlook and invite attendees, there doesn't appear to be a way to delete the meeting from ...
Deleted items folder is unavailable I noticed that my IMAP account was having issues with my upgrade from Microsoft Outlook 2007 to Microsoft Outlook 2010. I was trying to delete emails ...
MS Office 2016 activation with KMS Following the recent release of the Microsoft Office 2016 final RTM version, corporate customers can initiate their transition to new office platform....
Microsoft Office 2007 & 2010 Form Fields This is a short tutorial on enabling Form fields in Microsoft Office 2007 and Microsoft Office 2010. Microsoft Office 2007 Instructions Step 1 To a...
How to remove the Welcome to your new Office scree... Hey guys! Today we are going to show you a little bit about MS Office 2013 and Group Policies. We have been deploying MS Office 2013 to some clients a...
READ ALSO  KMPlayer Audio Sync Issues on AVI Files